Overview

Dataset info

Number of variables181
Number of observations2000
Missing cells240887 (66.5%)
Duplicate rows0 (0.0%)
Total size in memory2.7 MiB
Average record size in memory1.4 KiB

Variables types

Numeric47
Categorical26
Boolean16
Date0
URL0
Text (Unique)1
Rejected91
Unsupported0

Warnings

coligada_mais_antiga_ativa has 1737 (86.9%) missing values Missing
coligada_mais_antiga_baixada has constant value "nan" Rejected
coligada_mais_nova_ativa has 1737 (86.9%) missing values Missing
coligada_mais_nova_baixada has constant value "nan" Rejected
de_faixa_faturamento_estimado has 118 (5.9%) missing values Missing
de_faixa_faturamento_estimado_grupo has 118 (5.9%) missing values Missing
de_indicador_telefone has constant value "BOA" Rejected
de_nivel_atividade has 51 (2.5%) missing values Missing
de_saude_rescencia has 64 (3.2%) missing values Missing
de_saude_tributaria has 64 (3.2%) missing values Missing
dt_situacao only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
dt_situacao has a high cardinality: 1315 distinct values Warning
empsetorcensitariofaixarendapopulacao has 600 (30.0%) missing values Missing
faturamento_est_coligados has 1738 (86.9%) missing values Missing
faturamento_est_coligados_gp is highly correlated with faturamento_est_coligados (ρ = 0.95095) Rejected
fl_epp has constant value "False" Rejected
fl_optante_simei has 346 (17.3%) missing values Missing
fl_optante_simples has 346 (17.3%) missing values Missing
fl_spa has constant value "False" Rejected
fl_st_especial has constant value "False" Rejected
grau_instrucao_macro_analfabeto has 1994 (99.7%) missing values Missing
grau_instrucao_macro_desconhecido has constant value "nan" Rejected
grau_instrucao_macro_escolaridade_fundamental is highly correlated with grau_instrucao_macro_analfabeto (ρ = 0.99804) Rejected
grau_instrucao_macro_escolaridade_media has 1694 (84.7%) missing values Missing
grau_instrucao_macro_escolaridade_superior is highly correlated with grau_instrucao_macro_escolaridade_media (ρ = 0.91788) Rejected
idade_acima_de_58 is highly correlated with grau_instrucao_macro_analfabeto (ρ = 1) Rejected
idade_ate_18 has 1990 (99.5%) missing values Missing
idade_de_19_a_23 has 1879 (94.0%) missing values Missing
idade_de_24_a_28 is highly correlated with idade_de_19_a_23 (ρ = 0.90867) Rejected
idade_de_29_a_33 is highly correlated with grau_instrucao_macro_escolaridade_superior (ρ = 0.97492) Rejected
idade_de_34_a_38 is highly correlated with idade_de_29_a_33 (ρ = 0.99405) Rejected
idade_de_39_a_43 is highly correlated with idade_de_34_a_38 (ρ = 0.98349) Rejected
idade_de_44_a_48 is highly correlated with idade_de_39_a_43 (ρ = 0.94917) Rejected
idade_de_49_a_53 is highly correlated with grau_instrucao_macro_analfabeto (ρ = 0.98916) Rejected
idade_de_54_a_58 is highly correlated with idade_de_49_a_53 (ρ = 0.96175) Rejected
idade_maxima_coligadas is highly correlated with coligada_mais_antiga_ativa (ρ = 0.99976) Rejected
idade_maxima_socios has 659 (33.0%) missing values Missing
idade_media_coligadas has 1737 (86.9%) missing values Missing
idade_media_coligadas_ativas is highly correlated with idade_media_coligadas (ρ = 0.99964) Rejected
idade_media_coligadas_baixadas has constant value "nan" Rejected
idade_media_socios is highly correlated with idade_maxima_socios (ρ = 0.95544) Rejected
idade_minima_coligadas is highly correlated with coligada_mais_nova_ativa (ρ = 1) Rejected
idade_minima_socios is highly correlated with idade_media_socios (ρ = 0.95058) Rejected
max_faturamento_est_coligados is highly correlated with faturamento_est_coligados_gp (ρ = 0.93599) Rejected
max_faturamento_est_coligados_gp is highly correlated with max_faturamento_est_coligados (ρ = 0.95994) Rejected
max_filiais_coligados has 1919 (96.0%) missing values Missing
max_funcionarios_coligados_gp has 28 (1.4%) zeros Zeros
max_funcionarios_coligados_gp has 1830 (91.5%) missing values Missing
max_meses_servicos is highly correlated with grau_instrucao_macro_analfabeto (ρ = 0.96649) Rejected
max_meses_servicos_all is highly correlated with grau_instrucao_macro_analfabeto (ρ = 0.96649) Rejected
max_vl_folha_coligados has 1858 (92.9%) missing values Missing
max_vl_folha_coligados_gp is highly correlated with max_funcionarios_coligados_gp (ρ = 0.90484) Rejected
media_faturamento_est_coligados has 1738 (86.9%) missing values Missing
media_faturamento_est_coligados_gp is highly correlated with media_faturamento_est_coligados (ρ = 0.95038) Rejected
media_filiais_coligados has 1919 (96.0%) missing values Missing
media_funcionarios_coligados_gp has 28 (1.4%) zeros Zeros
media_funcionarios_coligados_gp has 1830 (91.5%) missing values Missing
media_meses_servicos is highly correlated with max_meses_servicos (ρ = 0.98685) Rejected
media_meses_servicos_all is highly correlated with grau_instrucao_macro_analfabeto (ρ = 0.97656) Rejected
media_vl_folha_coligados has 1858 (92.9%) missing values Missing
media_vl_folha_coligados_gp is highly correlated with media_funcionarios_coligados_gp (ρ = 0.90412) Rejected
meses_ultima_contratacaco has 1533 (76.6%) missing values Missing
min_faturamento_est_coligados has 1738 (86.9%) missing values Missing
min_faturamento_est_coligados_gp has 1738 (86.9%) missing values Missing
min_filiais_coligados is highly correlated with min_faturamento_est_coligados_gp (ρ = 0.94222) Rejected
min_funcionarios_coligados_gp is highly correlated with min_filiais_coligados (ρ = 0.90511) Rejected
min_meses_servicos is highly correlated with meses_ultima_contratacaco (ρ = 0.9357) Rejected
min_meses_servicos_all is highly correlated with grau_instrucao_macro_analfabeto (ρ = 0.98306) Rejected
min_vl_folha_coligados has 1858 (92.9%) missing values Missing
min_vl_folha_coligados_gp is highly correlated with min_vl_folha_coligados (ρ = 0.98176) Rejected
nm_divisao has a high cardinality: 72 distinct values Warning
nm_meso_regiao has 278 (13.9%) missing values Missing
nm_micro_regiao has a high cardinality: 73 distinct values Warning
nm_micro_regiao has 278 (13.9%) missing values Missing
nu_meses_rescencia has 199 (10.0%) missing values Missing
percent_func_genero_fem is highly correlated with grau_instrucao_macro_analfabeto (ρ = 0.94572) Rejected
percent_func_genero_masc has 83 (4.2%) zeros Zeros
percent_func_genero_masc has 1659 (83.0%) missing values Missing
qt_admitidos has 1533 (76.6%) missing values Missing
qt_admitidos_12meses has 342 (17.1%) zeros Zeros
qt_admitidos_12meses has 1533 (76.6%) missing values Missing
qt_alteracao_socio_180d has constant value "nan" Rejected
qt_alteracao_socio_365d has constant value "nan" Rejected
qt_alteracao_socio_90d has constant value "nan" Rejected
qt_alteracao_socio_total has constant value "nan" Rejected
qt_art has 1974 (98.7%) missing values Missing
qt_coligadas has 1791 (89.5%) missing values Missing
qt_coligados is highly correlated with qt_coligadas (ρ = 0.99508) Rejected
qt_coligados_agropecuaria has 1737 (86.9%) missing values Missing
qt_coligados_atividade_alto has constant value "0.0" Rejected
qt_coligados_atividade_baixo has constant value "0.0" Rejected
qt_coligados_atividade_inativo has constant value "0.0" Rejected
qt_coligados_atividade_medio has constant value "0.0" Rejected
qt_coligados_atividade_mt_baixo has constant value "0.0" Rejected
qt_coligados_ativo is highly correlated with qt_coligados (ρ = 0.99225) Rejected
qt_coligados_baixada is highly correlated with min_vl_folha_coligados_gp (ρ = 0.97761) Rejected
qt_coligados_ccivil has 212 (10.6%) zeros Zeros
qt_coligados_ccivil has 1737 (86.9%) missing values Missing
qt_coligados_centro has 255 (12.8%) zeros Zeros
qt_coligados_centro has 1737 (86.9%) missing values Missing
qt_coligados_comercio has 144 (7.2%) zeros Zeros
qt_coligados_comercio has 1737 (86.9%) missing values Missing
qt_coligados_epp has constant value "0.0" Rejected
qt_coligados_exterior has 1737 (86.9%) missing values Missing
qt_coligados_inapta has 1737 (86.9%) missing values Missing
qt_coligados_industria has 229 (11.5%) zeros Zeros
qt_coligados_industria has 1737 (86.9%) missing values Missing
qt_coligados_ltda has 1737 (86.9%) missing values Missing
qt_coligados_matriz is highly correlated with qt_coligados_ativo (ρ = 0.99409) Rejected
qt_coligados_me has 1737 (86.9%) missing values Missing
qt_coligados_mei has 1737 (86.9%) missing values Missing
qt_coligados_nordeste has 93 (4.7%) zeros Zeros
qt_coligados_nordeste has 1737 (86.9%) missing values Missing
qt_coligados_norte is highly correlated with idade_ate_18 (ρ = 0.90019) Rejected
qt_coligados_nula has constant value "0.0" Rejected
qt_coligados_sa is highly correlated with qt_coligados_matriz (ρ = 0.9177) Rejected
qt_coligados_serviço has 96 (4.8%) zeros Zeros
qt_coligados_serviço has 1737 (86.9%) missing values Missing
qt_coligados_sudeste is highly correlated with qt_coligados_sa (ρ = 0.91504) Rejected
qt_coligados_sul has 258 (12.9%) zeros Zeros
qt_coligados_sul has 1737 (86.9%) missing values Missing
qt_coligados_suspensa has constant value "0.0" Rejected
qt_desligados has 54 (2.7%) zeros Zeros
qt_desligados has 1533 (76.6%) missing values Missing
qt_desligados_12meses has 332 (16.6%) zeros Zeros
qt_desligados_12meses has 1533 (76.6%) missing values Missing
qt_ex_funcionarios is highly correlated with qt_desligados (ρ = 1) Rejected
qt_filiais is highly skewed (γ1 = 27.833) Skewed
qt_filiais has 1818 (90.9%) zeros Zeros
qt_funcionarios is highly correlated with idade_de_44_a_48 (ρ = 0.95213) Rejected
qt_funcionarios_12meses is highly correlated with qt_funcionarios (ρ = 0.987) Rejected
qt_funcionarios_24meses is highly correlated with qt_funcionarios_12meses (ρ = 0.98125) Rejected
qt_funcionarios_coligados is highly correlated with qt_coligados_sudeste (ρ = 0.90732) Rejected
qt_funcionarios_coligados_gp is highly correlated with max_funcionarios_coligados_gp (ρ = 0.97393) Rejected
qt_funcionarios_grupo is highly correlated with qt_filiais (ρ = 0.90038) Rejected
qt_ramos_coligados is highly correlated with qt_coligadas (ρ = 0.94424) Rejected
qt_regioes_coligados has 1737 (86.9%) missing values Missing
qt_socios has 502 (25.1%) missing values Missing
qt_socios_coligados is highly correlated with qt_funcionarios_coligados (ρ = 0.91132) Rejected
qt_socios_feminino has 1377 (68.8%) missing values Missing
qt_socios_masculino has 1139 (57.0%) missing values Missing
qt_socios_pep is highly correlated with qt_socios_masculino (ρ = 0.98678) Rejected
qt_socios_pf is highly correlated with qt_socios_pep (ρ = 0.93094) Rejected
qt_socios_pj has 502 (25.1%) missing values Missing
qt_socios_pj_ativos is highly correlated with qt_socios_pj (ρ = 1) Rejected
qt_socios_pj_baixados has constant value "0.0" Rejected
qt_socios_pj_inaptos has constant value "0.0" Rejected
qt_socios_pj_nulos has constant value "0.0" Rejected
qt_socios_pj_suspensos has constant value "0.0" Rejected
qt_socios_st_regular is highly correlated with qt_socios_pf (ρ = 0.96491) Rejected
qt_socios_st_suspensa has 1986 (99.3%) missing values Missing
qt_ufs_coligados has 1737 (86.9%) missing values Missing
sum_faturamento_estimado_coligadas is highly correlated with media_faturamento_est_coligados_gp (ρ = 0.99843) Rejected
total is highly correlated with qt_funcionarios_24meses (ρ = 0.99141) Rejected
total_filiais_coligados is highly correlated with qt_socios_coligados (ρ = 0.96516) Rejected
tx_crescimento_12meses has 210 (10.5%) zeros Zeros
tx_crescimento_12meses has 1658 (82.9%) missing values Missing
tx_crescimento_24meses has 131 (6.6%) zeros Zeros
tx_crescimento_24meses has 1646 (82.3%) missing values Missing
tx_rotatividade has 362 (18.1%) zeros Zeros
tx_rotatividade has 1533 (76.6%) missing values Missing
vl_faturamento_estimado_aux is highly correlated with total (ρ = 0.98498) Rejected
vl_faturamento_estimado_grupo_aux is highly correlated with qt_socios_st_suspensa (ρ = 0.94871) Rejected
vl_folha_coligados is highly correlated with qt_socios_pep (ρ = 0.94709) Rejected
vl_folha_coligados_gp is highly correlated with vl_folha_coligados (ρ = 0.92398) Rejected
vl_frota has 1885 (94.2%) missing values Missing
vl_idade_maxima_socios_pj has 1981 (99.1%) missing values Missing
vl_idade_media_socios_pj is highly correlated with vl_idade_maxima_socios_pj (ρ = 0.98045) Rejected
vl_idade_minima_socios_pj is highly correlated with vl_idade_media_socios_pj (ρ = 0.98102) Rejected
vl_potenc_cons_oleo_gas is highly correlated with vl_folha_coligados_gp (ρ = 0.99995) Rejected
vl_total_tancagem has constant value "nan" Rejected
vl_total_tancagem_grupo is highly correlated with vl_folha_coligados_gp (ρ = 1) Rejected
vl_total_veiculos_antt has constant value "nan" Rejected
vl_total_veiculos_antt_grupo has constant value "nan" Rejected
vl_total_veiculos_leves has 32 (1.6%) zeros Zeros
vl_total_veiculos_leves has 1864 (93.2%) missing values Missing
vl_total_veiculos_leves_grupo is highly skewed (γ1 = 44.237) Skewed
vl_total_veiculos_leves_grupo has 1834 (91.7%) zeros Zeros
vl_total_veiculos_pesados is highly correlated with vl_potenc_cons_oleo_gas (ρ = 0.91186) Rejected
vl_total_veiculos_pesados_grupo is highly correlated with vl_potenc_cons_oleo_gas (ρ = 0.90934) Rejected

Variables

coligada_mais_antiga_ativa
Numeric

Distinct count261
Unique (%)13.1%
Missing (%)86.9%
Missing (n)1737
Infinite (%)0.0%
Infinite (n)0
Mean219.55
Minimum1.7667
Maximum636.9
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.7667
5-th percentile39.197
Q1117.15
Median193.97
Q3280.18
95-th percentile538.3
Maximum636.9
Range635.13
Interquartile range163.03

Descriptive statistics

Standard deviation145.12
Coef of variation0.661
Kurtosis0.94297
Mean219.55
MAD111.28
Skewness1.0926
Sum57741
Variance21060
Memory size31.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
247.5 2 0.1%
 
231.13 2 0.1%
 
243.7 2 0.1%
 
262.6 1 0.1%
 
71.567 1 0.1%
 
538.47 1 0.1%
 
113.07 1 0.1%
 
294.77 1 0.1%
 
163.27 1 0.1%
 
358.97 1 0.1%
 
Other values (250) 250 12.5%
 
(Missing) 1737 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
1.7667 1 0.1%
 
5.2667 1 0.1%
 
11.267 1 0.1%
 
16.933 1 0.1%
 
23.767 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
636.9 1 0.1%
 
636.6 1 0.1%
 
636.03 1 0.1%
 
635.8 1 0.1%
 
635.07 1 0.1%
 

coligada_mais_antiga_baixada
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

coligada_mais_nova_ativa
Numeric

Distinct count253
Unique (%)12.7%
Missing (%)86.9%
Missing (n)1737
Infinite (%)0.0%
Infinite (n)0
Mean116.72
Minimum1.5333
Maximum634.4
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.5333
5-th percentile4.8767
Q142.3
Median87.8
Q3176.35
95-th percentile307.98
Maximum634.4
Range632.87
Interquartile range134.05

Descriptive statistics

Standard deviation99.6
Coef of variation0.85335
Kurtosis2.3595
Mean116.72
MAD79.01
Skewness1.3048
Sum30696
Variance9920.2
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
43.7 3 0.1%
 
86.067 2 0.1%
 
50.8 2 0.1%
 
37.933 2 0.1%
 
37.3 2 0.1%
 
2.7 2 0.1%
 
96.267 2 0.1%
 
243.7 2 0.1%
 
4.8333 2 0.1%
 
3.4 2 0.1%
 
Other values (242) 242 12.1%
 
(Missing) 1737 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
1.5333 1 0.1%
 
1.7667 1 0.1%
 
2.4667 1 0.1%
 
2.5 1 0.1%
 
2.7 2 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
634.4 1 0.1%
 
407.73 1 0.1%
 
389.97 1 0.1%
 
369.33 1 0.1%
 
365.57 1 0.1%
 

coligada_mais_nova_baixada
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

de_faixa_faturamento_estimado
Categorical

Distinct count10
Unique (%)0.5%
Missing (%)5.9%
Missing (n)118
DE R$ 81.000,01 A R$ 360.000,00
1166
ATE R$ 81.000,00
443
DE R$ 360.000,01 A R$ 1.500.000,00
 
200
Other values (6)
 
73
(Missing)
 
118
ValueCountFrequency (%) 
DE R$ 81.000,01 A R$ 360.000,00 1166 58.3%
 
ATE R$ 81.000,00 443 22.1%
 
DE R$ 360.000,01 A R$ 1.500.000,00 200 10.0%
 
DE R$ 1.500.000,01 A R$ 4.800.000,00 51 2.5%
 
DE R$ 4.800.000,01 A R$ 10.000.000,00 6 0.3%
 
SEM INFORMACAO 6 0.3%
 
DE R$ 10.000.000,01 A R$ 30.000.000,00 6 0.3%
 
DE R$ 30.000.000,01 A R$ 100.000.000,00 3 0.1%
 
DE R$ 300.000.000,01 A R$ 500.000.000,00 1 0.1%
 
(Missing) 118 5.9%
 
Max length40
Mean length26.457
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_faixa_faturamento_estimado_grupo
Categorical

Distinct count12
Unique (%)0.6%
Missing (%)5.9%
Missing (n)118
DE R$ 81.000,01 A R$ 360.000,00
1094
ATE R$ 81.000,00
438
DE R$ 360.000,01 A R$ 1.500.000,00
234
Other values (8)
 
116
(Missing)
 
118
ValueCountFrequency (%) 
DE R$ 81.000,01 A R$ 360.000,00 1094 54.7%
 
ATE R$ 81.000,00 438 21.9%
 
DE R$ 360.000,01 A R$ 1.500.000,00 234 11.7%
 
DE R$ 1.500.000,01 A R$ 4.800.000,00 51 2.5%
 
DE R$ 4.800.000,01 A R$ 10.000.000,00 16 0.8%
 
ACIMA DE 1 BILHAO DE REAIS 16 0.8%
 
DE R$ 10.000.000,01 A R$ 30.000.000,00 12 0.6%
 
DE R$ 30.000.000,01 A R$ 100.000.000,00 8 0.4%
 
DE R$ 100.000.000,01 A R$ 300.000.000,00 6 0.3%
 
DE R$ 500.000.000,01 A 1 BILHAO DE REAIS 5 0.2%
 
(Missing) 118 5.9%
 
Max length40
Mean length26.682
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_indicador_telefone
Constant

This variable is constant and should be ignored for analysis

Constant valueBOA

de_natureza_juridica
Categorical

Distinct count33
Unique (%)1.7%
Missing (%)0.0%
Missing (n)0
EMPRESARIO INDIVIDUAL
1306
SOCIEDADE EMPRESARIA LIMITADA
396
ASSOCIACAO PRIVADA
 
115
Other values (30)
 
183
ValueCountFrequency (%) 
EMPRESARIO INDIVIDUAL 1306 65.3%
 
SOCIEDADE EMPRESARIA LIMITADA 396 19.8%
 
ASSOCIACAO PRIVADA 115 5.8%
 
EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA 68 3.4%
 
ORGAO DE DIRECAO LOCAL DE PARTIDO POLITICO 24 1.2%
 
CANDIDATO A CARGO POLITICO ELETIVO 12 0.6%
 
ENTIDADE SINDICAL 7 0.4%
 
CONDOMINIO EDILICIO 7 0.4%
 
ORGANIZACAO RELIGIOSA 7 0.4%
 
SOCIEDADE SIMPLES LIMITADA 6 0.3%
 
Other values (23) 52 2.6%
 
Max length70
Mean length24.597
Min length9
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_nivel_atividade
Categorical

Distinct count5
Unique (%)0.2%
Missing (%)2.5%
Missing (n)51
MEDIA
933
ALTA
680
BAIXA
321
(Missing)
 
51
ValueCountFrequency (%) 
MEDIA 933 46.7%
 
ALTA 680 34.0%
 
BAIXA 321 16.1%
 
MUITO BAIXA 15 0.8%
 
(Missing) 51 2.5%
 
Max length11
Mean length4.654
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_ramo
Categorical

Distinct count31
Unique (%)1.6%
Missing (%)0.0%
Missing (n)0
COMERCIO VAREJISTA
749
SERVICOS DIVERSOS
229
SERVICOS DE ALOJAMENTO/ALIMENTACAO
 
133
Other values (28)
889
ValueCountFrequency (%) 
COMERCIO VAREJISTA 749 37.5%
 
SERVICOS DIVERSOS 229 11.5%
 
SERVICOS DE ALOJAMENTO/ALIMENTACAO 133 6.7%
 
INDUSTRIA DA CONSTRUCAO 122 6.1%
 
COMERCIO E REPARACAO DE VEICULOS 115 5.8%
 
SERVICOS ADMINISTRATIVOS 102 5.1%
 
BENS DE CONSUMO 85 4.2%
 
SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS 78 3.9%
 
COMERCIO POR ATACADO 63 3.1%
 
TRANSPORTE, ARMAZENAGEM E CORREIO 59 2.9%
 
Other values (21) 265 13.2%
 
Max length49
Mean length22.175
Min length6
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_saude_rescencia
Categorical

Distinct count4
Unique (%)0.2%
Missing (%)3.2%
Missing (n)64
ACIMA DE 1 ANO
1652
ATE 1 ANO
 
149
SEM INFORMACAO
 
135
(Missing)
 
64
ValueCountFrequency (%) 
ACIMA DE 1 ANO 1652 82.6%
 
ATE 1 ANO 149 7.4%
 
SEM INFORMACAO 135 6.8%
 
(Missing) 64 3.2%
 
Max length14
Mean length13.275
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_saude_tributaria
Categorical

Distinct count7
Unique (%)0.4%
Missing (%)3.2%
Missing (n)64
VERDE
679
AZUL
471
AMARELO
351
Other values (3)
435
ValueCountFrequency (%) 
VERDE 679 34.0%
 
AZUL 471 23.5%
 
AMARELO 351 17.5%
 
CINZA 262 13.1%
 
LARANJA 150 7.5%
 
VERMELHO 23 1.1%
 
(Missing) 64 3.2%
 
Max length8
Mean length5.236
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

dt_situacao
Categorical

Distinct count1315
Unique (%)65.8%
Missing (%)0.0%
Missing (n)0
2005-11-03
 
285
2006-12-01
 
13
2005-09-24
 
8
Other values (1312)
1694
ValueCountFrequency (%) 
2005-11-03 285 14.2%
 
2006-12-01 13 0.7%
 
2005-09-24 8 0.4%
 
2018-08-14 7 0.4%
 
2004-10-30 7 0.4%
 
2006-12-21 7 0.4%
 
2005-08-27 7 0.4%
 
2006-12-02 7 0.4%
 
2010-05-15 6 0.3%
 
1998-07-28 6 0.3%
 
Other values (1305) 1647 82.3%
 
Max length10
Mean length10
Min length10
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

empsetorcensitariofaixarendapopulacao
Numeric

Distinct count1231
Unique (%)61.6%
Missing (%)30.0%
Missing (n)600
Infinite (%)0.0%
Infinite (n)0
Mean1342.2
Minimum169.28
Maximum30862
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum169.28
5-th percentile449.45
Q1686.73
Median943.72
Q31539
95-th percentile3653.9
Maximum30862
Range30693
Interquartile range852.3

Descriptive statistics

Standard deviation1340.3
Coef of variation0.99859
Kurtosis173.63
Mean1342.2
MAD752.91
Skewness9.2164
Sum1.8791e+06
Variance1.7965e+06
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1549.1 9 0.4%
 
1086 6 0.3%
 
845.75 4 0.2%
 
2522.8 4 0.2%
 
1375.7 4 0.2%
 
1116.5 4 0.2%
 
786.74 3 0.1%
 
452.13 3 0.1%
 
1939.1 3 0.1%
 
1519.6 3 0.1%
 
Other values (1220) 1357 67.8%
 
(Missing) 600 30.0%
 

Minimum 5 values

ValueCountFrequency (%) 
169.28 1 0.1%
 
205.66 1 0.1%
 
247.88 1 0.1%
 
255.93 1 0.1%
 
262.44 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
30862 1 0.1%
 
12513 1 0.1%
 
10039 1 0.1%
 
7716.2 1 0.1%
 
6641.4 1 0.1%
 

faturamento_est_coligados
Numeric

Distinct count135
Unique (%)6.8%
Missing (%)86.9%
Missing (n)1738
Infinite (%)0.0%
Infinite (n)0
Mean3.251e+08
Minimum50000
Maximum2.7759e+10
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum50000
5-th percentile1.8668e+05
Q12.1e+05
Median6.8001e+05
Q32.515e+06
95-th percentile1.5139e+08
Maximum2.7759e+10
Range2.7759e+10
Interquartile range2.305e+06

Descriptive statistics

Standard deviation2.6192e+09
Coef of variation8.0565
Kurtosis93.975
Mean3.251e+08
MAD6.1382e+08
Skewness9.5289
Sum8.5176e+10
Variance6.86e+18
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.1e+05 68 3.4%
 
4.2e+05 14 0.7%
 
9.3e+05 11 0.5%
 
6.3e+05 7 0.4%
 
1.8546e+05 6 0.3%
 
3.7092e+05 5 0.2%
 
50000 5 0.2%
 
9.8911e+05 3 0.1%
 
1.2364e+05 3 0.1%
 
1.26e+06 3 0.1%
 
Other values (124) 137 6.9%
 
(Missing) 1738 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
50000 5 0.2%
 
1.2364e+05 3 0.1%
 
1.8546e+05 6 0.3%
 
2.1e+05 68 3.4%
 
2.4728e+05 2 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
2.7759e+10 1 0.1%
 
2.7536e+10 1 0.1%
 
1.5086e+10 1 0.1%
 
7.2571e+09 1 0.1%
 
2.1435e+09 1 0.1%
 

faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with faturamento_est_coligados and should be ignored for analysis

Correlation0.95095

fl_antt
Boolean

Distinct count3
Unique (%)0.1%
Missing (%)0.5%
Missing (n)11
False
1983
True
 
6
(Missing)
 
11
ValueCountFrequency (%) 
False 1983 99.2%
 
True 6 0.3%
 
(Missing) 11 0.5%
 

fl_email
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
False
1071
True
929
ValueCountFrequency (%) 
False 1071 53.5%
 
True 929 46.5%
 

fl_epp
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_ltda
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
False
1997
True
 
3
ValueCountFrequency (%) 
False 1997 99.9%
 
True 3 0.1%
 

fl_matriz
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
True
1893
False
 
107
ValueCountFrequency (%) 
True 1893 94.7%
 
False 107 5.3%
 

fl_me
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
False
1996
True
 
4
ValueCountFrequency (%) 
False 1996 99.8%
 
True 4 0.2%
 

fl_mei
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
False
1339
True
661
ValueCountFrequency (%) 
False 1339 67.0%
 
True 661 33.1%
 

fl_optante_simei
Boolean

Distinct count3
Unique (%)0.1%
Missing (%)17.3%
Missing (n)346
False
1233
True
421
(Missing)
346
ValueCountFrequency (%) 
False 1233 61.7%
 
True 421 21.1%
 
(Missing) 346 17.3%
 

fl_optante_simples
Boolean

Distinct count3
Unique (%)0.1%
Missing (%)17.3%
Missing (n)346
True
913
False
741
(Missing)
346
ValueCountFrequency (%) 
True 913 45.6%
 
False 741 37.0%
 
(Missing) 346 17.3%
 

fl_passivel_iss
Boolean

Distinct count3
Unique (%)0.1%
Missing (%)0.5%
Missing (n)11
True
1141
False
848
(Missing)
 
11
ValueCountFrequency (%) 
True 1141 57.0%
 
False 848 42.4%
 
(Missing) 11 0.5%
 

fl_rm
Categorical

Distinct count2
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
NAO
1008
SIM
992
ValueCountFrequency (%) 
NAO 1008 50.4%
 
SIM 992 49.6%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

fl_sa
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
False
1964
True
 
36
ValueCountFrequency (%) 
False 1964 98.2%
 
True 36 1.8%
 

fl_simples_irregular
Boolean

Distinct count3
Unique (%)0.1%
Missing (%)0.5%
Missing (n)11
False
1987
True
 
2
(Missing)
 
11
ValueCountFrequency (%) 
False 1987 99.4%
 
True 2 0.1%
 
(Missing) 11 0.5%
 

fl_spa
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_st_especial
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_telefone
Boolean

Distinct count2
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
True
1459
False
541
ValueCountFrequency (%) 
True 1459 73.0%
 
False 541 27.1%
 

fl_veiculo
Boolean

Distinct count3
Unique (%)0.1%
Missing (%)0.5%
Missing (n)11
False
1853
True
 
136
(Missing)
 
11
ValueCountFrequency (%) 
False 1853 92.7%
 
True 136 6.8%
 
(Missing) 11 0.5%
 

grau_instrucao_macro_analfabeto
Boolean

Distinct count3
Unique (%)0.1%
Missing (%)99.7%
Missing (n)1994
1
 
5
3
 
1
(Missing)
1994
ValueCountFrequency (%) 
1 5 0.2%
 
3 1 0.1%
 
(Missing) 1994 99.7%
 

grau_instrucao_macro_desconhecido
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

grau_instrucao_macro_escolaridade_fundamental
Highly correlated

This variable is highly correlated with grau_instrucao_macro_analfabeto and should be ignored for analysis

Correlation0.99804

grau_instrucao_macro_escolaridade_media
Numeric

Distinct count37
Unique (%)1.8%
Missing (%)84.7%
Missing (n)1694
Infinite (%)0.0%
Infinite (n)0
Mean8.6373
Minimum1
Maximum523
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median3
Q36
95-th percentile24.5
Maximum523
Range522
Interquartile range5

Descriptive statistics

Standard deviation33.488
Coef of variation3.8772
Kurtosis185.92
Mean8.6373
MAD9.6794
Skewness12.636
Sum2643
Variance1121.5
Memory size31.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 89 4.5%
 
2 56 2.8%
 
3 34 1.7%
 
4 25 1.2%
 
5 17 0.9%
 
6 17 0.9%
 
9 7 0.4%
 
7 7 0.4%
 
8 6 0.3%
 
10 6 0.3%
 
Other values (26) 42 2.1%
 
(Missing) 1694 84.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1 89 4.5%
 
2 56 2.8%
 
3 34 1.7%
 
4 25 1.2%
 
5 17 0.9%
 

Maximum 5 values

ValueCountFrequency (%) 
523 1 0.1%
 
177 1 0.1%
 
120 1 0.1%
 
94 1 0.1%
 
82 1 0.1%
 

grau_instrucao_macro_escolaridade_superior
Highly correlated

This variable is highly correlated with grau_instrucao_macro_escolaridade_media and should be ignored for analysis

Correlation0.91788

id
Categorical, Unique

First 5 values
00123b6e449556823ba4aac6dbb35b44f60557c511566f838dc889b75c6f9af1
0032e3e6a776cbf4d36efa963b4eda224ddba8af284117273bbd7a2a9d374f96
0036afe9a1be13d5389ab0d8f8cd2217c8c6076345298cb451f3634f44294ae0
008fd7836462aaecf8b8d335153ada057577156875fae4933a9fc16a2a44e0d0
00c30fb1779762241dd1ca7d1baab00c24b2f87294e573415ccfa23fda43c270
Last 5 values
ffba50aa6f4af7271d8f9738018b0f0329c89b05fe597100f833a07065a2c417
ffc04bac625e91c7ebad8dc98943264661aca3a913b5f634c2ae69a947772e13
ffd37fc0ee78a4555d0c18e10b3779e54581142875f0ad31f9ba0406fd5a9b2d
ffd81231de150c50400d79d1740ca8108eda5b339beb850646cdd9424bae405e
ffed1e47eaf7b3444605cd7cb91bf9ef7cf3bbe9f7f73092c10d21a1d454d1fd

First 5 values

ValueCountFrequency (%) 
00123b6e449556823ba4aac6dbb35b44f60557c511566f838dc889b75c6f9af1 1 0.1%
 
0032e3e6a776cbf4d36efa963b4eda224ddba8af284117273bbd7a2a9d374f96 1 0.1%
 
0036afe9a1be13d5389ab0d8f8cd2217c8c6076345298cb451f3634f44294ae0 1 0.1%
 
008fd7836462aaecf8b8d335153ada057577156875fae4933a9fc16a2a44e0d0 1 0.1%
 
00c30fb1779762241dd1ca7d1baab00c24b2f87294e573415ccfa23fda43c270 1 0.1%
 

Last 5 values

ValueCountFrequency (%) 
ffed1e47eaf7b3444605cd7cb91bf9ef7cf3bbe9f7f73092c10d21a1d454d1fd 1 0.1%
 
ffd81231de150c50400d79d1740ca8108eda5b339beb850646cdd9424bae405e 1 0.1%
 
ffd37fc0ee78a4555d0c18e10b3779e54581142875f0ad31f9ba0406fd5a9b2d 1 0.1%
 
ffc04bac625e91c7ebad8dc98943264661aca3a913b5f634c2ae69a947772e13 1 0.1%
 
ffba50aa6f4af7271d8f9738018b0f0329c89b05fe597100f833a07065a2c417 1 0.1%
 

idade_acima_de_58
Highly correlated

This variable is highly correlated with grau_instrucao_macro_analfabeto and should be ignored for analysis

Correlation1

idade_ate_18
Categorical

Distinct count4
Unique (%)0.2%
Missing (%)99.5%
Missing (n)1990
1
 
7
3
 
2
2
 
1
(Missing)
1990
ValueCountFrequency (%) 
1 7 0.4%
 
3 2 0.1%
 
2 1 0.1%
 
(Missing) 1990 99.5%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

idade_de_19_a_23
Numeric

Distinct count13
Unique (%)0.7%
Missing (%)94.0%
Missing (n)1879
Infinite (%)0.0%
Infinite (n)0
Mean2.4628
Minimum1
Maximum43
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile6
Maximum43
Range42
Interquartile range1

Descriptive statistics

Standard deviation4.4479
Coef of variation1.806
Kurtosis58.704
Mean2.4628
MAD1.9587
Skewness6.9266
Sum298
Variance19.784
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 75 3.8%
 
2 19 0.9%
 
3 10 0.5%
 
4 6 0.3%
 
5 4 0.2%
 
11 1 0.1%
 
12 1 0.1%
 
14 1 0.1%
 
10 1 0.1%
 
6 1 0.1%
 
Other values (2) 2 0.1%
 
(Missing) 1879 94.0%
 

Minimum 5 values

ValueCountFrequency (%) 
1 75 3.8%
 
2 19 0.9%
 
3 10 0.5%
 
4 6 0.3%
 
5 4 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
43 1 0.1%
 
15 1 0.1%
 
14 1 0.1%
 
12 1 0.1%
 
11 1 0.1%
 

idade_de_24_a_28
Highly correlated

This variable is highly correlated with idade_de_19_a_23 and should be ignored for analysis

Correlation0.90867

idade_de_29_a_33
Highly correlated

This variable is highly correlated with grau_instrucao_macro_escolaridade_superior and should be ignored for analysis

Correlation0.97492

idade_de_34_a_38
Highly correlated

This variable is highly correlated with idade_de_29_a_33 and should be ignored for analysis

Correlation0.99405

idade_de_39_a_43
Highly correlated

This variable is highly correlated with idade_de_34_a_38 and should be ignored for analysis

Correlation0.98349

idade_de_44_a_48
Highly correlated

This variable is highly correlated with idade_de_39_a_43 and should be ignored for analysis

Correlation0.94917

idade_de_49_a_53
Highly correlated

This variable is highly correlated with grau_instrucao_macro_analfabeto and should be ignored for analysis

Correlation0.98916

idade_de_54_a_58
Highly correlated

This variable is highly correlated with idade_de_49_a_53 and should be ignored for analysis

Correlation0.96175

idade_emp_cat
Categorical

Distinct count6
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
1 a 5
609
5 a 10
523
> 20
329
Other values (3)
539
ValueCountFrequency (%) 
1 a 5 609 30.4%
 
5 a 10 523 26.2%
 
> 20 329 16.4%
 
10 a 15 196 9.8%
 
<= 1 195 9.8%
 
15 a 20 148 7.4%
 
Max length7
Mean length5.3435
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

idade_empresa_anos
Numeric

Distinct count1669
Unique (%)83.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean9.9455
Minimum0.030137
Maximum52.115
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.030137
5-th percentile0.47123
Q12.7007
Median6.6466
Q314.391
95-th percentile30.719
Maximum52.115
Range52.085
Interquartile range11.69

Descriptive statistics

Standard deviation9.6906
Coef of variation0.97438
Kurtosis1.3867
Mean9.9455
MAD7.6071
Skewness1.3767
Sum19891
Variance93.909
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[3.01369863e-02 2.04109589e-01 2.09589041e-01 3.59452055e+00 9.28904110e+00 1.44876712e+01 2.41465753e+01 3.32712329e+01 4.19246575e+01 5.21150685e+01], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0.20548 7 0.4%
 
0.20822 5 0.2%
 
0.60548 4 0.2%
 
1.2548 4 0.2%
 
2.3945 4 0.2%
 
3.4603 4 0.2%
 
1.0274 4 0.2%
 
2.2164 4 0.2%
 
3.0603 4 0.2%
 
5.1945 4 0.2%
 
Other values (1659) 1956 97.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0.030137 2 0.1%
 
0.046575 1 0.1%
 
0.049315 1 0.1%
 
0.052055 1 0.1%
 
0.054795 2 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
52.115 1 0.1%
 
51.153 1 0.1%
 
49.438 1 0.1%
 
48.279 1 0.1%
 
47.326 1 0.1%
 

idade_maxima_coligadas
Highly correlated

This variable is highly correlated with coligada_mais_antiga_ativa and should be ignored for analysis

Correlation0.99976

idade_maxima_socios
Numeric

Distinct count73
Unique (%)3.6%
Missing (%)33.0%
Missing (n)659
Infinite (%)0.0%
Infinite (n)0
Mean44.687
Minimum18
Maximum96
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum18
5-th percentile25
Q134
Median43
Q354
95-th percentile70
Maximum96
Range78
Interquartile range20

Descriptive statistics

Standard deviation13.941
Coef of variation0.31197
Kurtosis-0.071414
Mean44.687
MAD11.359
Skewness0.54313
Sum59925
Variance194.35
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
41 46 2.3%
 
35 43 2.1%
 
30 40 2.0%
 
32 40 2.0%
 
40 39 1.9%
 
45 38 1.9%
 
47 38 1.9%
 
48 37 1.8%
 
39 37 1.8%
 
33 37 1.8%
 
Other values (62) 946 47.3%
 
(Missing) 659 33.0%
 

Minimum 5 values

ValueCountFrequency (%) 
18 1 0.1%
 
19 4 0.2%
 
20 7 0.4%
 
21 7 0.4%
 
22 14 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
96 1 0.1%
 
90 1 0.1%
 
87 2 0.1%
 
86 2 0.1%
 
85 1 0.1%
 

idade_media_coligadas
Numeric

Distinct count262
Unique (%)13.1%
Missing (%)86.9%
Missing (n)1737
Infinite (%)0.0%
Infinite (n)0
Mean159.21
Minimum1.7667
Maximum634.4
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.7667
5-th percentile37.777
Q188.3
Median148.63
Q3213.65
95-th percentile333.71
Maximum634.4
Range632.63
Interquartile range125.35

Descriptive statistics

Standard deviation92.859
Coef of variation0.58325
Kurtosis2.2092
Mean159.21
MAD72.529
Skewness1.0645
Sum41872
Variance8622.9
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
243.7 2 0.1%
 
87.644 2 0.1%
 
262.6 1 0.1%
 
85.85 1 0.1%
 
137.88 1 0.1%
 
23.767 1 0.1%
 
154.15 1 0.1%
 
121.41 1 0.1%
 
47.233 1 0.1%
 
16.933 1 0.1%
 
Other values (251) 251 12.6%
 
(Missing) 1737 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
1.7667 1 0.1%
 
5.2667 1 0.1%
 
11.267 1 0.1%
 
16.933 1 0.1%
 
23.767 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
634.4 1 0.1%
 
445.12 1 0.1%
 
407.73 1 0.1%
 
395.33 1 0.1%
 
392.85 1 0.1%
 

idade_media_coligadas_ativas
Highly correlated

This variable is highly correlated with idade_media_coligadas and should be ignored for analysis

Correlation0.99964

idade_media_coligadas_baixadas
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

idade_media_socios
Highly correlated

This variable is highly correlated with idade_maxima_socios and should be ignored for analysis

Correlation0.95544

idade_minima_coligadas
Highly correlated

This variable is highly correlated with coligada_mais_nova_ativa and should be ignored for analysis

Correlation1

idade_minima_socios
Highly correlated

This variable is highly correlated with idade_media_socios and should be ignored for analysis

Correlation0.95058

max_faturamento_est_coligados
Highly correlated

This variable is highly correlated with faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.93599

max_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados and should be ignored for analysis

Correlation0.95994

max_filiais_coligados
Numeric

Distinct count22
Unique (%)1.1%
Missing (%)96.0%
Missing (n)1919
Infinite (%)0.0%
Infinite (n)0
Mean12.383
Minimum1
Maximum349
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q35
95-th percentile46
Maximum349
Range348
Interquartile range4

Descriptive statistics

Standard deviation42.62
Coef of variation3.4419
Kurtosis50.596
Mean12.383
MAD17.062
Skewness6.7275
Sum1003
Variance1816.5
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 37 1.8%
 
2 16 0.8%
 
3 4 0.2%
 
5 3 0.1%
 
8 2 0.1%
 
6 2 0.1%
 
21 2 0.1%
 
4 2 0.1%
 
37 1 0.1%
 
7 1 0.1%
 
Other values (11) 11 0.5%
 
(Missing) 1919 96.0%
 

Minimum 5 values

ValueCountFrequency (%) 
1 37 1.8%
 
2 16 0.8%
 
3 4 0.2%
 
4 2 0.1%
 
5 3 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
349 1 0.1%
 
144 1 0.1%
 
67 1 0.1%
 
49 1 0.1%
 
46 1 0.1%
 

max_funcionarios_coligados_gp
Numeric

Distinct count61
Unique (%)3.0%
Missing (%)91.5%
Missing (n)1830
Infinite (%)0.0%
Infinite (n)0
Mean277.26
Minimum0
Maximum13234
Zeros (%)1.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q12
Median7
Q321
95-th percentile917.5
Maximum13234
Range13234
Interquartile range19

Descriptive statistics

Standard deviation1358.5
Coef of variation4.8996
Kurtosis58.608
Mean277.26
MAD469.54
Skewness7.2586
Sum47135
Variance1.8454e+06
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 28 1.4%
 
1 14 0.7%
 
8 10 0.5%
 
3 9 0.4%
 
6 9 0.4%
 
2 8 0.4%
 
4 7 0.4%
 
5 7 0.4%
 
7 5 0.2%
 
12 4 0.2%
 
Other values (50) 69 3.5%
 
(Missing) 1830 91.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 28 1.4%
 
1 14 0.7%
 
2 8 0.4%
 
3 9 0.4%
 
4 7 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
13234 1 0.1%
 
7646 1 0.1%
 
7612 1 0.1%
 
3719 1 0.1%
 
3278 1 0.1%
 

max_meses_servicos
Highly correlated

This variable is highly correlated with grau_instrucao_macro_analfabeto and should be ignored for analysis

Correlation0.96649

max_meses_servicos_all
Highly correlated

This variable is highly correlated with grau_instrucao_macro_analfabeto and should be ignored for analysis

Correlation0.96649

max_vl_folha_coligados
Numeric

Distinct count80
Unique (%)4.0%
Missing (%)92.9%
Missing (n)1858
Infinite (%)0.0%
Infinite (n)0
Mean1.776e+07
Minimum20606
Maximum1.0023e+09
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum20606
5-th percentile61819
Q11.8546e+05
Median5.5637e+05
Q31.3755e+06
95-th percentile4.9337e+07
Maximum1.0023e+09
Range1.0023e+09
Interquartile range1.19e+06

Descriptive statistics

Standard deviation9.4405e+07
Coef of variation5.3157
Kurtosis87.65
Mean1.776e+07
MAD2.9605e+07
Skewness8.8909
Sum2.5219e+09
Variance8.9124e+15
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
61819 15 0.8%
 
2.4728e+05 7 0.4%
 
1.2364e+05 6 0.3%
 
1.8546e+05 6 0.3%
 
4.9455e+05 4 0.2%
 
3.297e+05 3 0.1%
 
4.3273e+05 3 0.1%
 
6.1819e+05 3 0.1%
 
3.091e+05 3 0.1%
 
2.0606e+05 3 0.1%
 
Other values (69) 89 4.5%
 
(Missing) 1858 92.9%
 

Minimum 5 values

ValueCountFrequency (%) 
20606 2 0.1%
 
41213 1 0.1%
 
61819 15 0.8%
 
82426 2 0.1%
 
1.0303e+05 2 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1.0023e+09 1 0.1%
 
4.4242e+08 1 0.1%
 
1.9471e+08 1 0.1%
 
1.3491e+08 1 0.1%
 
1.3087e+08 1 0.1%
 

max_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with max_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.90484

media_faturamento_est_coligados
Numeric

Distinct count130
Unique (%)6.5%
Missing (%)86.9%
Missing (n)1738
Infinite (%)0.0%
Infinite (n)0
Mean1.3598e+07
Minimum50000
Maximum1.3219e+09
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum50000
5-th percentile1.8243e+05
Q12.1e+05
Median3.1098e+05
Q39.3e+05
95-th percentile1.4444e+07
Maximum1.3219e+09
Range1.3218e+09
Interquartile range7.2e+05

Descriptive statistics

Standard deviation9.7682e+07
Coef of variation7.1837
Kurtosis129.93
Mean1.3598e+07
MAD2.4052e+07
Skewness10.665
Sum3.5626e+09
Variance9.5418e+15
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.1e+05 95 4.8%
 
9.3e+05 12 0.6%
 
1.8546e+05 6 0.3%
 
3.7092e+05 5 0.2%
 
50000 5 0.2%
 
9.8911e+05 3 0.1%
 
1.6682e+05 2 0.1%
 
2.2864e+05 2 0.1%
 
1.8227e+05 2 0.1%
 
1.2364e+05 2 0.1%
 
Other values (119) 128 6.4%
 
(Missing) 1738 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
50000 5 0.2%
 
61819 1 0.1%
 
1.2364e+05 2 0.1%
 
1.5374e+05 1 0.1%
 
1.6682e+05 2 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1.3219e+09 1 0.1%
 
5.1837e+08 1 0.1%
 
5.0287e+08 1 0.1%
 
4.4174e+08 1 0.1%
 
2.3535e+08 1 0.1%
 

media_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados and should be ignored for analysis

Correlation0.95038

media_filiais_coligados
Numeric

Distinct count30
Unique (%)1.5%
Missing (%)96.0%
Missing (n)1919
Infinite (%)0.0%
Infinite (n)0
Mean4.4307
Minimum1
Maximum67
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1.5
Q33
95-th percentile14.5
Maximum67
Range66
Interquartile range2

Descriptive statistics

Standard deviation9.5355
Coef of variation2.1522
Kurtosis28.736
Mean4.4307
MAD4.6058
Skewness5.0724
Sum358.89
Variance90.927
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 37 1.8%
 
2 11 0.5%
 
1.5 4 0.2%
 
3 3 0.1%
 
4.5 2 0.1%
 
1.6667 1 0.1%
 
14.5 1 0.1%
 
2.5 1 0.1%
 
4 1 0.1%
 
8.5 1 0.1%
 
Other values (19) 19 0.9%
 
(Missing) 1919 96.0%
 

Minimum 5 values

ValueCountFrequency (%) 
1 37 1.8%
 
1.3333 1 0.1%
 
1.5 4 0.2%
 
1.6667 1 0.1%
 
2 11 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
67 1 0.1%
 
49.4 1 0.1%
 
20.667 1 0.1%
 
18 1 0.1%
 
14.5 1 0.1%
 

media_funcionarios_coligados_gp
Numeric

Distinct count71
Unique (%)3.5%
Missing (%)91.5%
Missing (n)1830
Infinite (%)0.0%
Infinite (n)0
Mean53.771
Minimum0
Maximum2162.4
Zeros (%)1.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q11.25
Median6
Q316
95-th percentile195.88
Maximum2162.4
Range2162.4
Interquartile range14.75

Descriptive statistics

Standard deviation213.88
Coef of variation3.9776
Kurtosis63.035
Mean53.771
MAD80.962
Skewness7.3682
Sum9141
Variance45743
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 28 1.4%
 
1 14 0.7%
 
6 10 0.5%
 
2 10 0.5%
 
3 9 0.4%
 
8 8 0.4%
 
5 7 0.4%
 
4 6 0.3%
 
21 6 0.3%
 
7 5 0.2%
 
Other values (60) 67 3.4%
 
(Missing) 1830 91.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 28 1.4%
 
0.66667 1 0.1%
 
1 14 0.7%
 
2 10 0.5%
 
3 9 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
2162.4 1 0.1%
 
1254.8 1 0.1%
 
931 1 0.1%
 
546 1 0.1%
 
479.83 1 0.1%
 

media_meses_servicos
Highly correlated

This variable is highly correlated with max_meses_servicos and should be ignored for analysis

Correlation0.98685

media_meses_servicos_all
Highly correlated

This variable is highly correlated with grau_instrucao_macro_analfabeto and should be ignored for analysis

Correlation0.97656

media_vl_folha_coligados
Numeric

Distinct count96
Unique (%)4.8%
Missing (%)92.9%
Missing (n)1858
Infinite (%)0.0%
Infinite (n)0
Mean4.1188e+06
Minimum20606
Maximum1.3491e+08
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum20606
5-th percentile61819
Q11.8546e+05
Median4.4304e+05
Q31.1334e+06
95-th percentile1.1696e+07
Maximum1.3491e+08
Range1.3489e+08
Interquartile range9.4789e+05

Descriptive statistics

Standard deviation1.6323e+07
Coef of variation3.9631
Kurtosis45.659
Mean4.1188e+06
MAD6.1598e+06
Skewness6.5235
Sum5.8487e+08
Variance2.6646e+14
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
61819 15 0.8%
 
1.8546e+05 6 0.3%
 
1.2364e+05 5 0.2%
 
2.4728e+05 4 0.2%
 
3.297e+05 3 0.1%
 
3.091e+05 3 0.1%
 
2.0606e+05 3 0.1%
 
4.9455e+05 3 0.1%
 
3.7092e+05 3 0.1%
 
1.0509e+06 2 0.1%
 
Other values (85) 95 4.8%
 
(Missing) 1858 92.9%
 

Minimum 5 values

ValueCountFrequency (%) 
20606 2 0.1%
 
41213 1 0.1%
 
61819 15 0.8%
 
61819 1 0.1%
 
82426 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1.3491e+08 1 0.1%
 
1.163e+08 1 0.1%
 
6.5405e+07 1 0.1%
 
4.1406e+07 1 0.1%
 
2.819e+07 1 0.1%
 

media_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with media_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.90412

meses_ultima_contratacaco
Numeric

Distinct count254
Unique (%)12.7%
Missing (%)76.6%
Missing (n)1533
Infinite (%)0.0%
Infinite (n)0
Mean40.529
Minimum2.0667
Maximum325.53
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2.0667
5-th percentile3.2533
Q110
Median32.733
Q358.167
95-th percentile106.22
Maximum325.53
Range323.47
Interquartile range48.167

Descriptive statistics

Standard deviation37.497
Coef of variation0.92518
Kurtosis8.3717
Mean40.529
MAD27.838
Skewness2.0336
Sum18927
Variance1406
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
5.9667 13 0.7%
 
2.9333 10 0.5%
 
40.5 9 0.4%
 
8.0333 8 0.4%
 
26.233 7 0.4%
 
6.9667 7 0.4%
 
39.467 7 0.4%
 
7 6 0.3%
 
23.2 6 0.3%
 
24.2 6 0.3%
 
Other values (243) 388 19.4%
 
(Missing) 1533 76.6%
 

Minimum 5 values

ValueCountFrequency (%) 
2.0667 1 0.1%
 
2.1333 1 0.1%
 
2.1667 1 0.1%
 
2.3 1 0.1%
 
2.4 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
325.53 1 0.1%
 
222.07 1 0.1%
 
178.4 1 0.1%
 
168.2 1 0.1%
 
167.23 1 0.1%
 

min_faturamento_est_coligados
Numeric

Distinct count42
Unique (%)2.1%
Missing (%)86.9%
Missing (n)1738
Infinite (%)0.0%
Infinite (n)0
Mean4.4692e+05
Minimum13946
Maximum1.4466e+07
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum13946
5-th percentile83804
Q12.1e+05
Median2.1e+05
Q32.1e+05
95-th percentile1.1127e+06
Maximum1.4466e+07
Range1.4452e+07
Interquartile range0

Descriptive statistics

Standard deviation1.0523e+06
Coef of variation2.3546
Kurtosis122.78
Mean4.4692e+05
MAD4.1037e+05
Skewness9.8582
Sum1.1709e+08
Variance1.1074e+12
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.1e+05 159 8.0%
 
9.3e+05 15 0.8%
 
1.8546e+05 13 0.7%
 
1.2364e+05 13 0.7%
 
3.7092e+05 6 0.3%
 
50000 5 0.2%
 
9.8911e+05 4 0.2%
 
2.4728e+05 4 0.2%
 
2.0606e+05 3 0.1%
 
82426 2 0.1%
 
Other values (31) 38 1.9%
 
(Missing) 1738 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
13946 1 0.1%
 
19079 1 0.1%
 
41213 2 0.1%
 
50000 5 0.2%
 
51516 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1.4466e+07 1 0.1%
 
4.657e+06 1 0.1%
 
3.7916e+06 1 0.1%
 
3.5855e+06 1 0.1%
 
3.194e+06 1 0.1%
 

min_faturamento_est_coligados_gp
Numeric

Distinct count56
Unique (%)2.8%
Missing (%)86.9%
Missing (n)1738
Infinite (%)0.0%
Infinite (n)0
Mean8.4177e+05
Minimum19079
Maximum8.1346e+07
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum19079
5-th percentile1.2364e+05
Q12.1e+05
Median2.1e+05
Q34.2e+05
95-th percentile1.8546e+06
Maximum8.1346e+07
Range8.1327e+07
Interquartile range2.1e+05

Descriptive statistics

Standard deviation5.122e+06
Coef of variation6.0848
Kurtosis236.44
Mean8.4177e+05
MAD9.9927e+05
Skewness15.074
Sum2.2054e+08
Variance2.6235e+13
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.1e+05 145 7.2%
 
9.3e+05 14 0.7%
 
1.2364e+05 13 0.7%
 
1.8546e+05 9 0.4%
 
4.2e+05 8 0.4%
 
3.7092e+05 5 0.2%
 
50000 5 0.2%
 
6.3e+05 4 0.2%
 
2.4728e+05 3 0.1%
 
1.1127e+06 3 0.1%
 
Other values (45) 53 2.6%
 
(Missing) 1738 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
19079 1 0.1%
 
41213 2 0.1%
 
50000 5 0.2%
 
51516 1 0.1%
 
61819 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
8.1346e+07 1 0.1%
 
1.4676e+07 1 0.1%
 
5.6089e+06 1 0.1%
 
4.657e+06 1 0.1%
 
4.451e+06 1 0.1%
 

min_filiais_coligados
Highly correlated

This variable is highly correlated with min_faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.94222

min_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with min_filiais_coligados and should be ignored for analysis

Correlation0.90511

min_meses_servicos
Highly correlated

This variable is highly correlated with meses_ultima_contratacaco and should be ignored for analysis

Correlation0.9357

min_meses_servicos_all
Highly correlated

This variable is highly correlated with grau_instrucao_macro_analfabeto and should be ignored for analysis

Correlation0.98306

min_vl_folha_coligados
Numeric

Distinct count47
Unique (%)2.4%
Missing (%)92.9%
Missing (n)1858
Infinite (%)0.0%
Infinite (n)0
Mean1.4262e+06
Minimum0
Maximum1.3491e+08
Zeros (%)0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile41213
Q161819
Median2.0606e+05
Q34.9455e+05
95-th percentile1.4218e+06
Maximum1.3491e+08
Range1.3491e+08
Interquartile range4.3273e+05

Descriptive statistics

Standard deviation1.1334e+07
Coef of variation7.9473
Kurtosis139.3
Mean1.4262e+06
MAD2.1156e+06
Skewness11.753
Sum2.0252e+08
Variance1.2847e+14
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
61819 28 1.4%
 
1.2364e+05 12 0.6%
 
1.8546e+05 8 0.4%
 
3.297e+05 6 0.3%
 
1.0303e+05 5 0.2%
 
20606 5 0.2%
 
2.0606e+05 5 0.2%
 
4.9455e+05 4 0.2%
 
6.1819e+05 4 0.2%
 
2.4728e+05 4 0.2%
 
Other values (36) 61 3.0%
 
(Missing) 1858 92.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 2 0.1%
 
20606 5 0.2%
 
41213 3 0.1%
 
61819 28 1.4%
 
82426 2 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1.3491e+08 1 0.1%
 
1.0365e+07 1 0.1%
 
7.2328e+06 1 0.1%
 
2.3285e+06 1 0.1%
 
1.9164e+06 1 0.1%
 

min_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with min_vl_folha_coligados and should be ignored for analysis

Correlation0.98176

natureza_juridica_macro
Categorical

Distinct count6
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
OUTROS
1406
ENTIDADES EMPRESARIAIS
426
ENTIDADES SEM FINS LUCRATIVOS
 
137
Other values (3)
 
31
ValueCountFrequency (%) 
OUTROS 1406 70.3%
 
ENTIDADES EMPRESARIAIS 426 21.3%
 
ENTIDADES SEM FINS LUCRATIVOS 137 6.9%
 
ADMINISTRACAO PUBLICA 15 0.8%
 
CARGO POLITICO 12 0.6%
 
PESSOAS FISICAS 4 0.2%
 
Max length29
Mean length11.162
Min length6
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_divisao
Categorical

Distinct count72
Unique (%)3.6%
Missing (%)0.5%
Missing (n)11
COMERCIO VAREJISTA
749
ATIVIDADES DE ORGANIZACOES ASSOCIATIVAS
 
140
ALIMENTACAO
 
121
Other values (68)
979
ValueCountFrequency (%) 
COMERCIO VAREJISTA 749 37.5%
 
ATIVIDADES DE ORGANIZACOES ASSOCIATIVAS 140 7.0%
 
ALIMENTACAO 121 6.0%
 
COMERCIO E REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS 115 5.8%
 
SERVICOS ESPECIALIZADOS PARA CONSTRUCAO 73 3.6%
 
COMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETAS 63 3.1%
 
OUTRAS ATIVIDADES DE SERVICOS PESSOAIS 54 2.7%
 
SERVICOS DE ESCRITORIO DE APOIO ADMINISTRATIVO E OUTROS SERVICOS PRESTADOS PRINCIPALMENTE AS EMPRESAS 52 2.6%
 
EDUCACAO 48 2.4%
 
CONSTRUCAO DE EDIFICIOS 42 2.1%
 
Other values (61) 532 26.6%
 
Max length120
Mean length33.612
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_meso_regiao
Categorical

Distinct count20
Unique (%)1.0%
Missing (%)13.9%
Missing (n)278
CENTRO AMAZONENSE
319
LESTE POTIGUAR
264
NORTE MARANHENSE
263
Other values (16)
876
(Missing)
278
ValueCountFrequency (%) 
CENTRO AMAZONENSE 319 16.0%
 
LESTE POTIGUAR 264 13.2%
 
NORTE MARANHENSE 263 13.2%
 
CENTRO NORTE PIAUIENSE 165 8.2%
 
OESTE MARANHENSE 101 5.1%
 
VALE DO ACRE 83 4.2%
 
OESTE POTIGUAR 78 3.9%
 
LESTE MARANHENSE 77 3.9%
 
CENTRO MARANHENSE 59 2.9%
 
SUDOESTE PIAUIENSE 59 2.9%
 
Other values (9) 254 12.7%
 
(Missing) 278 13.9%
 
Max length22
Mean length14.361
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_micro_regiao
Categorical

Distinct count73
Unique (%)3.6%
Missing (%)13.9%
Missing (n)278
MANAUS
256
NATAL
216
AGLOMERACAO URBANA DE SAO LUIS
 
206
Other values (69)
1044
(Missing)
278
ValueCountFrequency (%) 
MANAUS 256 12.8%
 
NATAL 216 10.8%
 
AGLOMERACAO URBANA DE SAO LUIS 206 10.3%
 
TERESINA 142 7.1%
 
RIO BRANCO 70 3.5%
 
IMPERATRIZ 56 2.8%
 
MOSSORO 39 1.9%
 
MEDIO MEARIM 35 1.8%
 
CAXIAS 32 1.6%
 
PINDARE 31 1.6%
 
Other values (62) 639 31.9%
 
(Missing) 278 13.9%
 
Max length33
Mean length11.012
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_segmento
Categorical

Distinct count21
Unique (%)1.1%
Missing (%)0.5%
Missing (n)11
COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS
927
OUTRAS ATIVIDADES DE SERVICOS
223
INDUSTRIAS DE TRANSFORMACAO
 
140
Other values (17)
699
ValueCountFrequency (%) 
COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS 927 46.4%
 
OUTRAS ATIVIDADES DE SERVICOS 223 11.2%
 
INDUSTRIAS DE TRANSFORMACAO 140 7.0%
 
ALOJAMENTO E ALIMENTACAO 133 6.7%
 
CONSTRUCAO 122 6.1%
 
ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES 102 5.1%
 
ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS 78 3.9%
 
TRANSPORTE ARMAZENAGEM E CORREIO 59 2.9%
 
SAUDE HUMANA E SERVICOS SOCIAIS 50 2.5%
 
EDUCACAO 48 2.4%
 
Other values (10) 107 5.3%
 
Max length62
Mean length42.663
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nu_meses_rescencia
Numeric

Distinct count26
Unique (%)1.3%
Missing (%)10.0%
Missing (n)199
Infinite (%)0.0%
Infinite (n)0
Mean25.313
Minimum7
Maximum54
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum7
5-th percentile9
Q122
Median23
Q325
95-th percentile48
Maximum54
Range47
Interquartile range3

Descriptive statistics

Standard deviation9.6847
Coef of variation0.3826
Kurtosis1.8594
Mean25.313
MAD5.9891
Skewness1.2775
Sum45588
Variance93.794
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
23 479 23.9%
 
22 357 17.8%
 
24 197 9.8%
 
48 125 6.2%
 
25 115 5.8%
 
26 113 5.7%
 
27 87 4.3%
 
21 51 2.5%
 
9 48 2.4%
 
47 39 1.9%
 
Other values (15) 190 9.5%
 
(Missing) 199 10.0%
 

Minimum 5 values

ValueCountFrequency (%) 
7 39 1.9%
 
8 17 0.9%
 
9 48 2.4%
 
10 16 0.8%
 
11 17 0.9%
 

Maximum 5 values

ValueCountFrequency (%) 
54 10 0.5%
 
52 3 0.1%
 
50 24 1.2%
 
49 20 1.0%
 
48 125 6.2%
 

percent_func_genero_fem
Highly correlated

This variable is highly correlated with grau_instrucao_macro_analfabeto and should be ignored for analysis

Correlation0.94572

percent_func_genero_masc
Numeric

Distinct count65
Unique (%)3.2%
Missing (%)83.0%
Missing (n)1659
Infinite (%)0.0%
Infinite (n)0
Mean53.985
Minimum0
Maximum100
Zeros (%)4.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q112.5
Median57.14
Q3100
95-th percentile100
Maximum100
Range100
Interquartile range87.5

Descriptive statistics

Standard deviation39.183
Coef of variation0.72581
Kurtosis-1.4939
Mean53.985
MAD34.864
Skewness-0.1815
Sum18409
Variance1535.3
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
100 94 4.7%
 
0 83 4.2%
 
50 28 1.4%
 
66.67 15 0.8%
 
33.33 13 0.7%
 
75 8 0.4%
 
83.33 7 0.4%
 
60 7 0.4%
 
25 7 0.4%
 
80 4 0.2%
 
Other values (54) 75 3.8%
 
(Missing) 1659 83.0%
 

Minimum 5 values

ValueCountFrequency (%) 
0 83 4.2%
 
11.11 2 0.1%
 
12.5 1 0.1%
 
14.29 1 0.1%
 
16 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
100 94 4.7%
 
98.04 1 0.1%
 
93.33 2 0.1%
 
93.24 1 0.1%
 
92.31 1 0.1%
 

qt_admitidos
Numeric

Distinct count85
Unique (%)4.2%
Missing (%)76.6%
Missing (n)1533
Infinite (%)0.0%
Infinite (n)0
Mean35.056
Minimum1
Maximum2000
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q12
Median6
Q318
95-th percentile147.8
Maximum2000
Range1999
Interquartile range16

Descriptive statistics

Standard deviation144.85
Coef of variation4.132
Kurtosis124.46
Mean35.056
MAD46.64
Skewness10.325
Sum16371
Variance20981
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 75 3.8%
 
2 55 2.8%
 
3 33 1.7%
 
4 30 1.5%
 
6 22 1.1%
 
5 21 1.1%
 
8 17 0.9%
 
7 17 0.9%
 
9 15 0.8%
 
17 11 0.5%
 
Other values (74) 171 8.6%
 
(Missing) 1533 76.6%
 

Minimum 5 values

ValueCountFrequency (%) 
1 75 3.8%
 
2 55 2.8%
 
3 33 1.7%
 
4 30 1.5%
 
5 21 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
2000 1 0.1%
 
1812 1 0.1%
 
890 1 0.1%
 
687 1 0.1%
 
647 1 0.1%
 

qt_admitidos_12meses
Numeric

Distinct count22
Unique (%)1.1%
Missing (%)76.6%
Missing (n)1533
Infinite (%)0.0%
Infinite (n)0
Mean1.2099
Minimum0
Maximum65
Zeros (%)17.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile6
Maximum65
Range65
Interquartile range1

Descriptive statistics

Standard deviation4.8411
Coef of variation4.0014
Kurtosis87.575
Mean1.2099
MAD1.8304
Skewness8.3432
Sum565
Variance23.437
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 342 17.1%
 
1 65 3.2%
 
2 16 0.8%
 
3 10 0.5%
 
4 7 0.4%
 
6 6 0.3%
 
12 4 0.2%
 
5 2 0.1%
 
7 2 0.1%
 
14 2 0.1%
 
Other values (11) 11 0.5%
 
(Missing) 1533 76.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 342 17.1%
 
1 65 3.2%
 
2 16 0.8%
 
3 10 0.5%
 
4 7 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
65 1 0.1%
 
46 1 0.1%
 
35 1 0.1%
 
28 1 0.1%
 
21 1 0.1%
 

qt_alteracao_socio_180d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_365d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_90d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_total
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_art
Numeric

Distinct count8
Unique (%)0.4%
Missing (%)98.7%
Missing (n)1974
Infinite (%)0.0%
Infinite (n)0
Mean2.8462
Minimum1
Maximum14
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q33
95-th percentile10.25
Maximum14
Range13
Interquartile range2

Descriptive statistics

Standard deviation3.2704
Coef of variation1.1491
Kurtosis5.8384
Mean2.8462
MAD2.0947
Skewness2.4747
Sum74
Variance10.695
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%) 
1 12 0.6%
 
2 6 0.3%
 
3 4 0.2%
 
14 1 0.1%
 
5 1 0.1%
 
11 1 0.1%
 
8 1 0.1%
 
(Missing) 1974 98.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1 12 0.6%
 
2 6 0.3%
 
3 4 0.2%
 
5 1 0.1%
 
8 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
14 1 0.1%
 
11 1 0.1%
 
8 1 0.1%
 
5 1 0.1%
 
3 4 0.2%
 

qt_coligadas
Numeric

Distinct count14
Unique (%)0.7%
Missing (%)89.5%
Missing (n)1791
Infinite (%)0.0%
Infinite (n)0
Mean2.2919
Minimum1
Maximum26
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile7
Maximum26
Range25
Interquartile range1

Descriptive statistics

Standard deviation2.6883
Coef of variation1.173
Kurtosis31.346
Mean2.2919
MAD1.5992
Skewness4.5917
Sum479
Variance7.2269
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 121 6.0%
 
2 37 1.8%
 
3 18 0.9%
 
5 10 0.5%
 
4 6 0.3%
 
7 5 0.2%
 
6 4 0.2%
 
8 3 0.1%
 
26 1 0.1%
 
14 1 0.1%
 
Other values (3) 3 0.1%
 
(Missing) 1791 89.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 121 6.0%
 
2 37 1.8%
 
3 18 0.9%
 
4 6 0.3%
 
5 10 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
26 1 0.1%
 
14 1 0.1%
 
13 1 0.1%
 
11 1 0.1%
 
9 1 0.1%
 

qt_coligados
Highly correlated

This variable is highly correlated with qt_coligadas and should be ignored for analysis

Correlation0.99508

qt_coligados_agropecuaria
Categorical

Distinct count5
Unique (%)0.2%
Missing (%)86.9%
Missing (n)1737
0
 
248
1
 
11
2
 
3
(Missing)
1737
ValueCountFrequency (%) 
0 248 12.4%
 
1 11 0.5%
 
2 3 0.1%
 
4 1 0.1%
 
(Missing) 1737 86.9%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_coligados_atividade_alto
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_atividade_baixo
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_atividade_inativo
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_atividade_medio
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_atividade_mt_baixo
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_ativo
Highly correlated

This variable is highly correlated with qt_coligados and should be ignored for analysis

Correlation0.99225

qt_coligados_baixada
Highly correlated

This variable is highly correlated with min_vl_folha_coligados_gp and should be ignored for analysis

Correlation0.97761

qt_coligados_ccivil
Numeric

Distinct count7
Unique (%)0.4%
Missing (%)86.9%
Missing (n)1737
Infinite (%)0.0%
Infinite (n)0
Mean0.35361
Minimum0
Maximum6
Zeros (%)10.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile2
Maximum6
Range6
Interquartile range0

Descriptive statistics

Standard deviation0.93309
Coef of variation2.6387
Kurtosis16.15
Mean0.35361
MAD0.57008
Skewness3.7275
Sum93
Variance0.87066
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%) 
0 212 10.6%
 
1 30 1.5%
 
2 12 0.6%
 
3 4 0.2%
 
5 3 0.1%
 
6 2 0.1%
 
(Missing) 1737 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 212 10.6%
 
1 30 1.5%
 
2 12 0.6%
 
3 4 0.2%
 
5 3 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
6 2 0.1%
 
5 3 0.1%
 
3 4 0.2%
 
2 12 0.6%
 
1 30 1.5%
 

qt_coligados_centro
Numeric

Distinct count6
Unique (%)0.3%
Missing (%)86.9%
Missing (n)1737
Infinite (%)0.0%
Infinite (n)0
Mean0.087452
Minimum0
Maximum6
Zeros (%)12.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum6
Range6
Interquartile range0

Descriptive statistics

Standard deviation0.60212
Coef of variation6.8851
Kurtosis74.317
Mean0.087452
MAD0.16958
Skewness8.314
Sum23
Variance0.36255
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%) 
0 255 12.8%
 
1 3 0.1%
 
3 2 0.1%
 
6 2 0.1%
 
2 1 0.1%
 
(Missing) 1737 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 255 12.8%
 
1 3 0.1%
 
2 1 0.1%
 
3 2 0.1%
 
6 2 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
6 2 0.1%
 
3 2 0.1%
 
2 1 0.1%
 
1 3 0.1%
 
0 255 12.8%
 

qt_coligados_comercio
Numeric

Distinct count14
Unique (%)0.7%
Missing (%)86.9%
Missing (n)1737
Infinite (%)0.0%
Infinite (n)0
Mean0.9962
Minimum0
Maximum20
Zeros (%)7.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile4
Maximum20
Range20
Interquartile range1

Descriptive statistics

Standard deviation2.0611
Coef of variation2.069
Kurtosis32.125
Mean0.9962
MAD1.0909
Skewness4.7676
Sum262
Variance4.2481
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 144 7.2%
 
1 70 3.5%
 
2 27 1.4%
 
3 7 0.4%
 
8 3 0.1%
 
6 3 0.1%
 
4 2 0.1%
 
5 2 0.1%
 
10 1 0.1%
 
7 1 0.1%
 
Other values (3) 3 0.1%
 
(Missing) 1737 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 144 7.2%
 
1 70 3.5%
 
2 27 1.4%
 
3 7 0.4%
 
4 2 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
20 1 0.1%
 
11 1 0.1%
 
10 1 0.1%
 
9 1 0.1%
 
8 3 0.1%
 

qt_coligados_epp
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_exterior
Categorical

Distinct count5
Unique (%)0.2%
Missing (%)86.9%
Missing (n)1737
0
 
257
2
 
3
1
 
2
(Missing)
1737
ValueCountFrequency (%) 
0 257 12.8%
 
2 3 0.1%
 
1 2 0.1%
 
3 1 0.1%
 
(Missing) 1737 86.9%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_coligados_inapta
Categorical

Distinct count4
Unique (%)0.2%
Missing (%)86.9%
Missing (n)1737
0
 
258
1
 
3
2
 
2
(Missing)
1737
ValueCountFrequency (%) 
0 258 12.9%
 
1 3 0.1%
 
2 2 0.1%
 
(Missing) 1737 86.9%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_coligados_industria
Numeric

Distinct count7
Unique (%)0.4%
Missing (%)86.9%
Missing (n)1737
Infinite (%)0.0%
Infinite (n)0
Mean0.64259
Minimum0
Maximum111
Zeros (%)11.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum111
Range111
Interquartile range0

Descriptive statistics

Standard deviation6.9029
Coef of variation10.742
Kurtosis252.12
Mean0.64259
MAD1.119
Skewness15.743
Sum169
Variance47.65
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%) 
0 229 11.5%
 
1 24 1.2%
 
3 4 0.2%
 
2 4 0.2%
 
111 1 0.1%
 
14 1 0.1%
 
(Missing) 1737 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 229 11.5%
 
1 24 1.2%
 
2 4 0.2%
 
3 4 0.2%
 
14 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
111 1 0.1%
 
14 1 0.1%
 
3 4 0.2%
 
2 4 0.2%
 
1 24 1.2%
 

qt_coligados_ltda
Categorical

Distinct count4
Unique (%)0.2%
Missing (%)86.9%
Missing (n)1737
0
 
251
1
 
9
2
 
3
(Missing)
1737
ValueCountFrequency (%) 
0 251 12.6%
 
1 9 0.4%
 
2 3 0.1%
 
(Missing) 1737 86.9%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_coligados_matriz
Highly correlated

This variable is highly correlated with qt_coligados_ativo and should be ignored for analysis

Correlation0.99409

qt_coligados_me
Boolean

Distinct count3
Unique (%)0.1%
Missing (%)86.9%
Missing (n)1737
0
 
262
1
 
1
(Missing)
1737
ValueCountFrequency (%) 
0 262 13.1%
 
1 1 0.1%
 
(Missing) 1737 86.9%
 

qt_coligados_mei
Categorical

Distinct count4
Unique (%)0.2%
Missing (%)86.9%
Missing (n)1737
0
 
255
1
 
7
2
 
1
(Missing)
1737
ValueCountFrequency (%) 
0 255 12.8%
 
1 7 0.4%
 
2 1 0.1%
 
(Missing) 1737 86.9%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_coligados_nordeste
Numeric

Distinct count17
Unique (%)0.9%
Missing (%)86.9%
Missing (n)1737
Infinite (%)0.0%
Infinite (n)0
Mean2
Minimum0
Maximum36
Zeros (%)4.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q32
95-th percentile7
Maximum36
Range36
Interquartile range2

Descriptive statistics

Standard deviation4.0095
Coef of variation2.0048
Kurtosis34.703
Mean2
MAD2.038
Skewness5.2401
Sum526
Variance16.076
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 93 4.7%
 
1 82 4.1%
 
2 38 1.9%
 
3 13 0.7%
 
5 8 0.4%
 
6 6 0.3%
 
7 6 0.3%
 
4 5 0.2%
 
8 5 0.2%
 
16 1 0.1%
 
Other values (6) 6 0.3%
 
(Missing) 1737 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 93 4.7%
 
1 82 4.1%
 
2 38 1.9%
 
3 13 0.7%
 
4 5 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
36 1 0.1%
 
31 1 0.1%
 
25 1 0.1%
 
20 1 0.1%
 
16 1 0.1%
 

qt_coligados_norte
Highly correlated

This variable is highly correlated with idade_ate_18 and should be ignored for analysis

Correlation0.90019

qt_coligados_nula
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_sa
Highly correlated

This variable is highly correlated with qt_coligados_matriz and should be ignored for analysis

Correlation0.9177

qt_coligados_serviço
Numeric

Distinct count17
Unique (%)0.9%
Missing (%)86.9%
Missing (n)1737
Infinite (%)0.0%
Infinite (n)0
Mean1.7681
Minimum0
Maximum20
Zeros (%)4.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q32
95-th percentile7
Maximum20
Range20
Interquartile range2

Descriptive statistics

Standard deviation2.8904
Coef of variation1.6348
Kurtosis14.514
Mean1.7681
MAD1.8047
Skewness3.3526
Sum465
Variance8.3544
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 96 4.8%
 
1 88 4.4%
 
2 27 1.4%
 
3 15 0.8%
 
7 9 0.4%
 
4 7 0.4%
 
5 6 0.3%
 
6 4 0.2%
 
8 4 0.2%
 
17 1 0.1%
 
Other values (6) 6 0.3%
 
(Missing) 1737 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 96 4.8%
 
1 88 4.4%
 
2 27 1.4%
 
3 15 0.8%
 
4 7 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
20 1 0.1%
 
19 1 0.1%
 
17 1 0.1%
 
15 1 0.1%
 
11 1 0.1%
 

qt_coligados_sudeste
Highly correlated

This variable is highly correlated with qt_coligados_sa and should be ignored for analysis

Correlation0.91504

qt_coligados_sul
Numeric

Distinct count6
Unique (%)0.3%
Missing (%)86.9%
Missing (n)1737
Infinite (%)0.0%
Infinite (n)0
Mean0.045627
Minimum0
Maximum5
Zeros (%)12.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum5
Range5
Interquartile range0

Descriptive statistics

Standard deviation0.38805
Coef of variation8.5047
Kurtosis116.65
Mean0.045627
MAD0.08952
Skewness10.306
Sum12
Variance0.15058
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%) 
0 258 12.9%
 
1 2 0.1%
 
2 1 0.1%
 
3 1 0.1%
 
5 1 0.1%
 
(Missing) 1737 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 258 12.9%
 
1 2 0.1%
 
2 1 0.1%
 
3 1 0.1%
 
5 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
5 1 0.1%
 
3 1 0.1%
 
2 1 0.1%
 
1 2 0.1%
 
0 258 12.9%
 

qt_coligados_suspensa
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_desligados
Numeric

Distinct count76
Unique (%)3.8%
Missing (%)76.6%
Missing (n)1533
Infinite (%)0.0%
Infinite (n)0
Mean25.101
Minimum0
Maximum1985
Zeros (%)2.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q11
Median4
Q312
95-th percentile107.1
Maximum1985
Range1985
Interquartile range11

Descriptive statistics

Standard deviation112.35
Coef of variation4.476
Kurtosis207.52
Mean25.101
MAD34.379
Skewness12.958
Sum11722
Variance12623
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 81 4.0%
 
2 57 2.9%
 
0 54 2.7%
 
4 32 1.6%
 
3 26 1.3%
 
6 24 1.2%
 
5 17 0.9%
 
7 15 0.8%
 
11 14 0.7%
 
8 11 0.5%
 
Other values (65) 136 6.8%
 
(Missing) 1533 76.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 54 2.7%
 
1 81 4.0%
 
2 57 2.9%
 
3 26 1.3%
 
4 32 1.6%
 

Maximum 5 values

ValueCountFrequency (%) 
1985 1 0.1%
 
865 1 0.1%
 
585 1 0.1%
 
451 2 0.1%
 
290 1 0.1%
 

qt_desligados_12meses
Numeric

Distinct count17
Unique (%)0.9%
Missing (%)76.6%
Missing (n)1533
Infinite (%)0.0%
Infinite (n)0
Mean1.469
Minimum0
Maximum233
Zeros (%)16.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile4
Maximum233
Range233
Interquartile range1

Descriptive statistics

Standard deviation11.19
Coef of variation7.6175
Kurtosis395.85
Mean1.469
MAD2.2111
Skewness19.246
Sum686
Variance125.21
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 332 16.6%
 
1 61 3.0%
 
2 23 1.1%
 
3 17 0.9%
 
4 11 0.5%
 
6 6 0.3%
 
5 4 0.2%
 
10 3 0.1%
 
9 2 0.1%
 
25 2 0.1%
 
Other values (6) 6 0.3%
 
(Missing) 1533 76.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 332 16.6%
 
1 61 3.0%
 
2 23 1.1%
 
3 17 0.9%
 
4 11 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
233 1 0.1%
 
40 1 0.1%
 
25 2 0.1%
 
24 1 0.1%
 
14 1 0.1%
 

qt_ex_funcionarios
Highly correlated

This variable is highly correlated with qt_desligados and should be ignored for analysis

Correlation1

qt_filiais
Numeric

Distinct count42
Unique (%)2.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean13.996
Minimum0
Maximum9270
Zeros (%)90.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum9270
Range9270
Interquartile range0

Descriptive statistics

Standard deviation284.47
Coef of variation20.325
Kurtosis830.78
Mean13.996
MAD27.188
Skewness27.833
Sum27992
Variance80925
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0.000e+00 5.000e-01 1.500e+00 2.500e+00 4.500e+00 9.500e+00 6.200e+01 4.665e+02 9.270e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 1818 90.9%
 
1 87 4.3%
 
2 26 1.3%
 
3 12 0.6%
 
4 8 0.4%
 
5 3 0.1%
 
8 3 0.1%
 
9 3 0.1%
 
59 2 0.1%
 
7 2 0.1%
 
Other values (32) 36 1.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1818 90.9%
 
1 87 4.3%
 
2 26 1.3%
 
3 12 0.6%
 
4 8 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
9270 1 0.1%
 
7687 1 0.1%
 
2537 1 0.1%
 
2186 1 0.1%
 
1715 1 0.1%
 

qt_funcionarios
Highly correlated

This variable is highly correlated with idade_de_44_a_48 and should be ignored for analysis

Correlation0.95213

qt_funcionarios_12meses
Highly correlated

This variable is highly correlated with qt_funcionarios and should be ignored for analysis

Correlation0.987

qt_funcionarios_24meses
Highly correlated

This variable is highly correlated with qt_funcionarios_12meses and should be ignored for analysis

Correlation0.98125

qt_funcionarios_coligados
Highly correlated

This variable is highly correlated with qt_coligados_sudeste and should be ignored for analysis

Correlation0.90732

qt_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with max_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.97393

qt_funcionarios_grupo
Highly correlated

This variable is highly correlated with qt_filiais and should be ignored for analysis

Correlation0.90038

qt_ramos_coligados
Highly correlated

This variable is highly correlated with qt_coligadas and should be ignored for analysis

Correlation0.94424

qt_regioes_coligados
Categorical

Distinct count5
Unique (%)0.2%
Missing (%)86.9%
Missing (n)1737
1
 
232
2
 
22
4
 
5
(Missing)
1737
ValueCountFrequency (%) 
1 232 11.6%
 
2 22 1.1%
 
4 5 0.2%
 
3 4 0.2%
 
(Missing) 1737 86.9%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_socios
Numeric

Distinct count14
Unique (%)0.7%
Missing (%)25.1%
Missing (n)502
Infinite (%)0.0%
Infinite (n)0
Mean1.3945
Minimum1
Maximum37
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile2.15
Maximum37
Range36
Interquartile range1

Descriptive statistics

Standard deviation1.3499
Coef of variation0.96799
Kurtosis350.99
Mean1.3945
MAD0.58837
Skewness15.301
Sum2089
Variance1.8222
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 1117 55.9%
 
2 306 15.3%
 
3 42 2.1%
 
4 12 0.6%
 
5 8 0.4%
 
6 4 0.2%
 
9 2 0.1%
 
8 2 0.1%
 
19 1 0.1%
 
11 1 0.1%
 
Other values (3) 3 0.1%
 
(Missing) 502 25.1%
 

Minimum 5 values

ValueCountFrequency (%) 
1 1117 55.9%
 
2 306 15.3%
 
3 42 2.1%
 
4 12 0.6%
 
5 8 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
37 1 0.1%
 
19 1 0.1%
 
14 1 0.1%
 
11 1 0.1%
 
9 2 0.1%
 

qt_socios_coligados
Highly correlated

This variable is highly correlated with qt_funcionarios_coligados and should be ignored for analysis

Correlation0.91132

qt_socios_feminino
Numeric

Distinct count6
Unique (%)0.3%
Missing (%)68.8%
Missing (n)1377
Infinite (%)0.0%
Infinite (n)0
Mean1.1091
Minimum1
Maximum11
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q31
95-th percentile2
Maximum11
Range10
Interquartile range0

Descriptive statistics

Standard deviation0.53281
Coef of variation0.48038
Kurtosis196.68
Mean1.1091
MAD0.20113
Skewness11.744
Sum691
Variance0.28389
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%) 
1 574 28.7%
 
2 40 2.0%
 
3 7 0.4%
 
5 1 0.1%
 
11 1 0.1%
 
(Missing) 1377 68.8%
 

Minimum 5 values

ValueCountFrequency (%) 
1 574 28.7%
 
2 40 2.0%
 
3 7 0.4%
 
5 1 0.1%
 
11 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
11 1 0.1%
 
5 1 0.1%
 
3 7 0.4%
 
2 40 2.0%
 
1 574 28.7%
 

qt_socios_masculino
Numeric

Distinct count9
Unique (%)0.4%
Missing (%)57.0%
Missing (n)1139
Infinite (%)0.0%
Infinite (n)0
Mean1.2218
Minimum1
Maximum32
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q31
95-th percentile2
Maximum32
Range31
Interquartile range0

Descriptive statistics

Standard deviation1.2088
Coef of variation0.98933
Kurtosis491.47
Mean1.2218
MAD0.38493
Skewness19.847
Sum1052
Variance1.4612
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%) 
1 747 37.4%
 
2 89 4.5%
 
3 12 0.6%
 
4 6 0.3%
 
5 3 0.1%
 
6 2 0.1%
 
8 1 0.1%
 
32 1 0.1%
 
(Missing) 1139 57.0%
 

Minimum 5 values

ValueCountFrequency (%) 
1 747 37.4%
 
2 89 4.5%
 
3 12 0.6%
 
4 6 0.3%
 
5 3 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
32 1 0.1%
 
8 1 0.1%
 
6 2 0.1%
 
5 3 0.1%
 
4 6 0.3%
 

qt_socios_pep
Highly correlated

This variable is highly correlated with qt_socios_masculino and should be ignored for analysis

Correlation0.98678

qt_socios_pf
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation0.93094

qt_socios_pj
Categorical

Distinct count5
Unique (%)0.2%
Missing (%)25.1%
Missing (n)502
0
1479
1
 
12
2
 
6
(Missing)
502
ValueCountFrequency (%) 
0 1479 74.0%
 
1 12 0.6%
 
2 6 0.3%
 
3 1 0.1%
 
(Missing) 502 25.1%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_socios_pj_ativos
Highly correlated

This variable is highly correlated with qt_socios_pj and should be ignored for analysis

Correlation1

qt_socios_pj_baixados
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_socios_pj_inaptos
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_socios_pj_nulos
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_socios_pj_suspensos
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_socios_st_regular
Highly correlated

This variable is highly correlated with qt_socios_pf and should be ignored for analysis

Correlation0.96491

qt_socios_st_suspensa
Boolean

Distinct count3
Unique (%)0.1%
Missing (%)99.3%
Missing (n)1986
1
 
13
2
 
1
(Missing)
1986
ValueCountFrequency (%) 
1 13 0.7%
 
2 1 0.1%
 
(Missing) 1986 99.3%
 

qt_ufs_coligados
Numeric

Distinct count9
Unique (%)0.4%
Missing (%)86.9%
Missing (n)1737
Infinite (%)0.0%
Infinite (n)0
Mean1.3384
Minimum1
Maximum8
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q31
95-th percentile3
Maximum8
Range7
Interquartile range0

Descriptive statistics

Standard deviation0.97072
Coef of variation0.72528
Kurtosis17.295
Mean1.3384
MAD0.561
Skewness3.8942
Sum352
Variance0.9423
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%) 
1 218 10.9%
 
2 27 1.4%
 
3 6 0.3%
 
5 5 0.2%
 
4 4 0.2%
 
6 1 0.1%
 
7 1 0.1%
 
8 1 0.1%
 
(Missing) 1737 86.9%
 

Minimum 5 values

ValueCountFrequency (%) 
1 218 10.9%
 
2 27 1.4%
 
3 6 0.3%
 
4 4 0.2%
 
5 5 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
8 1 0.1%
 
7 1 0.1%
 
6 1 0.1%
 
5 5 0.2%
 
4 4 0.2%
 

setor
Categorical

Distinct count6
Unique (%)0.3%
Missing (%)0.5%
Missing (n)11
COMERCIO
927
SERVIÇO
792
INDUSTRIA
 
134
Other values (2)
 
136
ValueCountFrequency (%) 
COMERCIO 927 46.4%
 
SERVIÇO 792 39.6%
 
INDUSTRIA 134 6.7%
 
CONSTRUÇÃO CIVIL 122 6.1%
 
AGROPECUARIA 14 0.7%
 
(Missing) 11 0.5%
 
Max length16
Mean length8.1595
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

sg_uf
Categorical

Distinct count6
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
MA
534
RN
415
AM
353
Other values (3)
698
ValueCountFrequency (%) 
MA 534 26.7%
 
RN 415 20.8%
 
AM 353 17.6%
 
PI 328 16.4%
 
RO 266 13.3%
 
AC 104 5.2%
 
Max length2
Mean length2
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

sg_uf_matriz
Categorical

Distinct count18
Unique (%)0.9%
Missing (%)0.5%
Missing (n)11
MA
523
RN
410
AM
347
Other values (14)
709
ValueCountFrequency (%) 
MA 523 26.2%
 
RN 410 20.5%
 
AM 347 17.3%
 
PI 320 16.0%
 
RO 259 13.0%
 
AC 99 5.0%
 
DF 7 0.4%
 
SP 5 0.2%
 
RJ 4 0.2%
 
CE 3 0.1%
 
Other values (7) 12 0.6%
 
(Missing) 11 0.5%
 
Max length3
Mean length2.0055
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

sum_faturamento_estimado_coligadas
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.99843

total
Highly correlated

This variable is highly correlated with qt_funcionarios_24meses and should be ignored for analysis

Correlation0.99141

total_filiais_coligados
Highly correlated

This variable is highly correlated with qt_socios_coligados and should be ignored for analysis

Correlation0.96516

tx_crescimento_12meses
Numeric

Distinct count69
Unique (%)3.5%
Missing (%)82.9%
Missing (n)1658
Infinite (%)0.0%
Infinite (n)0
Mean-3.747
Minimum-100
Maximum216.67
Zeros (%)10.5%
Mini histogram

Quantile statistics

Minimum-100
5-th percentile-50
Q10
Median0
Q30
95-th percentile35.986
Maximum216.67
Range316.67
Interquartile range0

Descriptive statistics

Standard deviation31.371
Coef of variation-8.3724
Kurtosis10.551
Mean-3.747
MAD16.57
Skewness0.50356
Sum-1281.5
Variance984.16
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 210 10.5%
 
-100 12 0.6%
 
-33.333 10 0.5%
 
-50 9 0.4%
 
50 8 0.4%
 
-25 7 0.4%
 
-14.286 5 0.2%
 
25 5 0.2%
 
100 3 0.1%
 
33.333 3 0.1%
 
Other values (58) 70 3.5%
 
(Missing) 1658 82.9%
 

Minimum 5 values

ValueCountFrequency (%) 
-100 12 0.6%
 
-93.827 1 0.1%
 
-83.333 1 0.1%
 
-62.5 1 0.1%
 
-60 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
216.67 1 0.1%
 
128.57 1 0.1%
 
100 3 0.1%
 
84.211 1 0.1%
 
57.143 1 0.1%
 

tx_crescimento_24meses
Numeric

Distinct count95
Unique (%)4.8%
Missing (%)82.3%
Missing (n)1646
Infinite (%)0.0%
Infinite (n)0
Mean-13.952
Minimum-100
Maximum600
Zeros (%)6.6%
Mini histogram

Quantile statistics

Minimum-100
5-th percentile-100
Q1-42.262
Median0
Q30
95-th percentile68.689
Maximum600
Range700
Interquartile range42.262

Descriptive statistics

Standard deviation64.885
Coef of variation-4.6505
Kurtosis28.544
Mean-13.952
MAD37.592
Skewness3.7693
Sum-4939.2
Variance4210.1
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 131 6.6%
 
-100 39 1.9%
 
-50 17 0.9%
 
-25 12 0.6%
 
-33.333 11 0.5%
 
100 8 0.4%
 
-20 8 0.4%
 
-66.667 7 0.4%
 
-40 6 0.3%
 
200 4 0.2%
 
Other values (84) 111 5.5%
 
(Missing) 1646 82.3%
 

Minimum 5 values

ValueCountFrequency (%) 
-100 39 1.9%
 
-94.737 1 0.1%
 
-90.909 1 0.1%
 
-87.5 1 0.1%
 
-85.714 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
600 1 0.1%
 
400 1 0.1%
 
300 1 0.1%
 
200 4 0.2%
 
125 1 0.1%
 

tx_rotatividade
Numeric

Distinct count69
Unique (%)3.5%
Missing (%)76.6%
Missing (n)1533
Infinite (%)0.0%
Infinite (n)0
Mean8.1273
Minimum0
Maximum200
Zeros (%)18.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile40
Maximum200
Range200
Interquartile range0

Descriptive statistics

Standard deviation22.028
Coef of variation2.7103
Kurtosis29.054
Mean8.1273
MAD12.694
Skewness4.6626
Sum3795.4
Variance485.22
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 362 18.1%
 
33.333 9 0.4%
 
28.571 8 0.4%
 
40 7 0.4%
 
25 4 0.2%
 
15.385 2 0.1%
 
16.667 2 0.1%
 
23.529 2 0.1%
 
11.765 2 0.1%
 
90.909 2 0.1%
 
Other values (58) 67 3.4%
 
(Missing) 1533 76.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 362 18.1%
 
2.9412 1 0.1%
 
4 1 0.1%
 
4.6512 1 0.1%
 
5 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
200 1 0.1%
 
190.98 1 0.1%
 
150 1 0.1%
 
133.33 1 0.1%
 
90.909 2 0.1%
 

vl_faturamento_estimado_aux
Highly correlated

This variable is highly correlated with total and should be ignored for analysis

Correlation0.98498

vl_faturamento_estimado_grupo_aux
Highly correlated

This variable is highly correlated with qt_socios_st_suspensa and should be ignored for analysis

Correlation0.94871

vl_folha_coligados
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation0.94709

vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with vl_folha_coligados and should be ignored for analysis

Correlation0.92398

vl_frota
Numeric

Distinct count112
Unique (%)5.6%
Missing (%)94.2%
Missing (n)1885
Infinite (%)0.0%
Infinite (n)0
Mean1.0161e+05
Minimum1680
Maximum7.8304e+05
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1680
5-th percentile4225.6
Q129530
Median57476
Q31.0689e+05
95-th percentile3.5427e+05
Maximum7.8304e+05
Range7.8136e+05
Interquartile range77360

Descriptive statistics

Standard deviation1.3409e+05
Coef of variation1.3196
Kurtosis9.3441
Mean1.0161e+05
MAD86046
Skewness2.8708
Sum1.1685e+07
Variance1.7979e+10
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
72838 2 0.1%
 
98819 2 0.1%
 
39289 2 0.1%
 
41298 2 0.1%
 
76140 1 0.1%
 
8069 1 0.1%
 
1.6912e+05 1 0.1%
 
2.4183e+05 1 0.1%
 
71556 1 0.1%
 
7.8304e+05 1 0.1%
 
Other values (101) 101 5.1%
 
(Missing) 1885 94.2%
 

Minimum 5 values

ValueCountFrequency (%) 
1680 1 0.1%
 
2429 1 0.1%
 
3306 1 0.1%
 
3375 1 0.1%
 
3392 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
7.8304e+05 1 0.1%
 
6.5655e+05 1 0.1%
 
5.6122e+05 1 0.1%
 
5.377e+05 1 0.1%
 
4.8123e+05 1 0.1%
 

vl_idade_maxima_socios_pj
Numeric

Distinct count19
Unique (%)0.9%
Missing (%)99.1%
Missing (n)1981
Infinite (%)0.0%
Infinite (n)0
Mean10.944
Minimum1.3142
Maximum30.064
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.3142
5-th percentile3.9877
Q16.9774
Median9.8782
Q312.557
95-th percentile24.01
Maximum30.064
Range28.75
Interquartile range5.5797

Descriptive statistics

Standard deviation6.8002
Coef of variation0.62138
Kurtosis2.6795
Mean10.944
MAD4.7569
Skewness1.4634
Sum207.93
Variance46.242
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
9.8782 2 0.1%
 
23.337 1 0.1%
 
6.1191 1 0.1%
 
15.343 1 0.1%
 
4.5941 1 0.1%
 
30.064 1 0.1%
 
13.374 1 0.1%
 
5.8371 1 0.1%
 
8.8843 1 0.1%
 
8.2656 1 0.1%
 
Other values (8) 8 0.4%
 
(Missing) 1981 99.1%
 

Minimum 5 values

ValueCountFrequency (%) 
1.3142 1 0.1%
 
4.2847 1 0.1%
 
4.5941 1 0.1%
 
5.8371 1 0.1%
 
6.1191 1 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
30.064 1 0.1%
 
23.337 1 0.1%
 
16.575 1 0.1%
 
15.343 1 0.1%
 
13.374 1 0.1%
 

vl_idade_media_socios_pj
Highly correlated

This variable is highly correlated with vl_idade_maxima_socios_pj and should be ignored for analysis

Correlation0.98045

vl_idade_minima_socios_pj
Highly correlated

This variable is highly correlated with vl_idade_media_socios_pj and should be ignored for analysis

Correlation0.98102

vl_potenc_cons_oleo_gas
Highly correlated

This variable is highly correlated with vl_folha_coligados_gp and should be ignored for analysis

Correlation0.99995

vl_total_tancagem
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

vl_total_tancagem_grupo
Highly correlated

This variable is highly correlated with vl_folha_coligados_gp and should be ignored for analysis

Correlation1

vl_total_veiculos_antt
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

vl_total_veiculos_antt_grupo
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

vl_total_veiculos_leves
Numeric

Distinct count13
Unique (%)0.7%
Missing (%)93.2%
Missing (n)1864
Infinite (%)0.0%
Infinite (n)0
Mean1.6103
Minimum0
Maximum24
Zeros (%)1.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q11
Median1
Q32
95-th percentile5
Maximum24
Range24
Interquartile range1

Descriptive statistics

Standard deviation2.6025
Coef of variation1.6162
Kurtosis41.789
Mean1.6103
MAD1.3501
Skewness5.5447
Sum219
Variance6.7729
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 66 3.3%
 
0 32 1.6%
 
2 18 0.9%
 
3 7 0.4%
 
4 4 0.2%
 
5 3 0.1%
 
11 1 0.1%
 
8 1 0.1%
 
24 1 0.1%
 
9 1 0.1%
 
Other values (2) 2 0.1%
 
(Missing) 1864 93.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 32 1.6%
 
1 66 3.3%
 
2 18 0.9%
 
3 7 0.4%
 
4 4 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
24 1 0.1%
 
11 1 0.1%
 
9 1 0.1%
 
8 1 0.1%
 
7 1 0.1%
 

vl_total_veiculos_leves_grupo
Numeric

Distinct count35
Unique (%)1.8%
Missing (%)0.5%
Missing (n)11
Infinite (%)0.0%
Infinite (n)0
Mean21.327
Minimum0
Maximum35064
Zeros (%)91.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum35064
Range35064
Interquartile range0

Descriptive statistics

Standard deviation788.34
Coef of variation36.965
Kurtosis1966.9
Mean21.327
MAD41.802
Skewness44.237
Sum42419
Variance6.2147e+05
Memory size111.2 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1834 91.7%
 
1 71 3.5%
 
2 26 1.3%
 
3 9 0.4%
 
4 7 0.4%
 
8 5 0.2%
 
5 4 0.2%
 
88 2 0.1%
 
6 2 0.1%
 
18 2 0.1%
 
Other values (24) 27 1.4%
 
(Missing) 11 0.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1834 91.7%
 
1 71 3.5%
 
2 26 1.3%
 
3 9 0.4%
 
4 7 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
35064 1 0.1%
 
2134 1 0.1%
 
888 1 0.1%
 
782 1 0.1%
 
479 1 0.1%
 

vl_total_veiculos_pesados
Highly correlated

This variable is highly correlated with vl_potenc_cons_oleo_gas and should be ignored for analysis

Correlation0.91186

vl_total_veiculos_pesados_grupo
Highly correlated

This variable is highly correlated with vl_potenc_cons_oleo_gas and should be ignored for analysis

Correlation0.90934

Correlations

Missing values

Sample

First rows

coligada_mais_antiga_ativacoligada_mais_antiga_baixadacoligada_mais_nova_ativacoligada_mais_nova_baixadade_faixa_faturamento_estimadode_faixa_faturamento_estimado_grupode_indicador_telefonede_natureza_juridicade_nivel_atividadede_ramode_saude_rescenciade_saude_tributariadt_situacaoempsetorcensitariofaixarendapopulacaofaturamento_est_coligadosfaturamento_est_coligados_gpfl_anttfl_emailfl_eppfl_ltdafl_matrizfl_mefl_meifl_optante_simeifl_optante_simplesfl_passivel_issfl_rmfl_safl_simples_irregularfl_spafl_st_especialfl_telefonefl_veiculograu_instrucao_macro_analfabetograu_instrucao_macro_desconhecidograu_instrucao_macro_escolaridade_fundamentalgrau_instrucao_macro_escolaridade_mediagrau_instrucao_macro_escolaridade_superiorididade_acima_de_58idade_ate_18idade_de_19_a_23idade_de_24_a_28idade_de_29_a_33idade_de_34_a_38idade_de_39_a_43idade_de_44_a_48idade_de_49_a_53idade_de_54_a_58idade_emp_catidade_empresa_anosidade_maxima_coligadasidade_maxima_sociosidade_media_coligadasidade_media_coligadas_ativasidade_media_coligadas_baixadasidade_media_sociosidade_minima_coligadasidade_minima_sociosmax_faturamento_est_coligadosmax_faturamento_est_coligados_gpmax_filiais_coligadosmax_funcionarios_coligados_gpmax_meses_servicosmax_meses_servicos_allmax_vl_folha_coligadosmax_vl_folha_coligados_gpmedia_faturamento_est_coligadosmedia_faturamento_est_coligados_gpmedia_filiais_coligadosmedia_funcionarios_coligados_gpmedia_meses_servicosmedia_meses_servicos_allmedia_vl_folha_coligadosmedia_vl_folha_coligados_gpmeses_ultima_contratacacomin_faturamento_est_coligadosmin_faturamento_est_coligados_gpmin_filiais_coligadosmin_funcionarios_coligados_gpmin_meses_servicosmin_meses_servicos_allmin_vl_folha_coligadosmin_vl_folha_coligados_gpnatureza_juridica_macronm_divisaonm_meso_regiaonm_micro_regiaonm_segmentonu_meses_rescenciapercent_func_genero_fempercent_func_genero_mascqt_admitidosqt_admitidos_12mesesqt_alteracao_socio_180dqt_alteracao_socio_365dqt_alteracao_socio_90dqt_alteracao_socio_totalqt_artqt_coligadasqt_coligadosqt_coligados_agropecuariaqt_coligados_atividade_altoqt_coligados_atividade_baixoqt_coligados_atividade_inativoqt_coligados_atividade_medioqt_coligados_atividade_mt_baixoqt_coligados_ativoqt_coligados_baixadaqt_coligados_ccivilqt_coligados_centroqt_coligados_comercioqt_coligados_eppqt_coligados_exteriorqt_coligados_inaptaqt_coligados_industriaqt_coligados_ltdaqt_coligados_matrizqt_coligados_meqt_coligados_meiqt_coligados_nordesteqt_coligados_norteqt_coligados_nulaqt_coligados_saqt_coligados_serviçoqt_coligados_sudesteqt_coligados_sulqt_coligados_suspensaqt_desligadosqt_desligados_12mesesqt_ex_funcionariosqt_filiaisqt_funcionariosqt_funcionarios_12mesesqt_funcionarios_24mesesqt_funcionarios_coligadosqt_funcionarios_coligados_gpqt_funcionarios_grupoqt_ramos_coligadosqt_regioes_coligadosqt_sociosqt_socios_coligadosqt_socios_femininoqt_socios_masculinoqt_socios_pepqt_socios_pfqt_socios_pjqt_socios_pj_ativosqt_socios_pj_baixadosqt_socios_pj_inaptosqt_socios_pj_nulosqt_socios_pj_suspensosqt_socios_st_regularqt_socios_st_suspensaqt_ufs_coligadossetorsg_ufsg_uf_matrizsum_faturamento_estimado_coligadastotaltotal_filiais_coligadostx_crescimento_12mesestx_crescimento_24mesestx_rotatividadevl_faturamento_estimado_auxvl_faturamento_estimado_grupo_auxvl_folha_coligadosvl_folha_coligados_gpvl_frotavl_idade_maxima_socios_pjvl_idade_media_socios_pjvl_idade_minima_socios_pjvl_potenc_cons_oleo_gasvl_total_tancagemvl_total_tancagem_grupovl_total_veiculos_anttvl_total_veiculos_antt_grupovl_total_veiculos_levesvl_total_veiculos_leves_grupovl_total_veiculos_pesadosvl_total_veiculos_pesados_grupo
0536.366667NaN57.3NaNDE R$ 1.500.000,01 A R$ 4.800.000,00DE R$ 1.500.000,01 A R$ 4.800.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTAINDUSTRIA DA CONSTRUCAOACIMA DE 1 ANOVERDE2005-03-25NaN21809443.022019443.0FalseTrueFalseFalseTrueFalseFalseFalseTrueTrueSIMFalseFalseFalseFalseTrueFalseNaNNaN1.025.0NaNa6984c3ae395090e3bee8ad63c3758b110de096d5d819583a784a113726db8491.0NaN1.04.06.05.03.04.02.0NaN10 a 1514.457534536.36666747.0220.477778220.477778NaN44.057.341.013188096.013188096.01.091.093.26666793.2666675275238.55275238.53.634907e+063.669907e+061.00000036.2543.73846213.3091952343978.02343978.019.166667210000.0210000.01.06.019.166667-0.933333638798.4638798.4ENTIDADES EMPRESARIAISCONSTRUCAO DE EDIFICIOSLESTE POTIGUARNATALCONSTRUCAO23.00.0100.0145.00.0NaNNaNNaNNaN8.06.06.00.00.00.00.00.00.06.00.00.00.01.00.00.00.00.00.06.00.00.06.00.00.00.05.00.00.00.0119.00.0119.0026.026.027.0145.0145.026.05.01.02.08.0NaN2.0NaN2.00.0NaNNaNNaNNaNNaN2.0NaN2.0CONSTRUÇÃO CIVILRNRN21809443.026.01.00.0-3.7037040.03132172.83132172.89375912.09375912.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
1NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALBAIXASERVICOS DE ALOJAMENTO/ALIMENTACAOATE 1 ANOCINZA2017-05-12468.93NaNNaNFalseTrueFalseFalseTrueFalseTrueNaNNaNTrueSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN6178f41ade1365e44bc2c46654c2c8c0eaae27dcb476c47fdef50b33f4f56f05NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 51.463014NaN27.0NaNNaNNaN27.0NaN27.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSALIMENTACAOCENTRO NORTE PIAUIENSETERESINAALOJAMENTO E ALIMENTACAO9.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇOPIPINaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
2NaNNaNNaNNaNATE R$ 81.000,00ATE R$ 81.000,00NaNEMPRESARIO INDIVIDUALMEDIATRANSPORTE, ARMAZENAGEM E CORREIOACIMA DE 1 ANOAMARELO2011-09-26713.50NaNNaNFalseFalseFalseFalseTrueFalseTrueTrueTrueTrueSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN4a7e5069a397f12fdd7fd57111d6dc5d3ba558958efc02edc5147bc2a2535b08NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN5 a 107.093151NaN32.0NaNNaNNaN32.0NaN32.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSTRANSPORTE TERRESTRECENTRO AMAZONENSEMANAUSTRANSPORTE ARMAZENAGEM E CORREIO26.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaNNaN1.0NaNSERVIÇOAMAMNaNNaNNaNNaNNaNNaN50000.050000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
3NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALMEDIASERVICOS DIVERSOSACIMA DE 1 ANOAMARELO2012-04-25475.73NaNNaNFalseTrueFalseFalseTrueFalseFalseFalseTrueTrueSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN3348900fe63216a439d2e5238c79ddd46ede454df7b9d8c24ac33eb21d4b21efNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN5 a 106.512329NaN36.0NaNNaNNaN36.0NaN36.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSREPARACAO E MANUTENCAO DE EQUIPAMENTOS DE INFORMATICA E COMUNICACAO E DE OBJETOS PESSOAIS E DOMESTICOSCENTRO AMAZONENSEMANAUSOUTRAS ATIVIDADES DE SERVICOS26.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇOAMAMNaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
4NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALALTASERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOSACIMA DE 1 ANOVERDE2015-08-172874.04NaNNaNFalseTrueFalseFalseTrueFalseFalseFalseTrueTrueSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN1f9bcabc9d3173c1fe769899e4fac14b053037b953a1e4b102c769f7611ab29fNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 53.200000NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSSERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ANALISES TECNICASLESTE POTIGUARNATALATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS27.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaNNaNNaN1.00.0NaNNaNNaNNaNNaNNaNNaNNaNSERVIÇORNRNNaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
5NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNSOCIEDADE EMPRESARIA LIMITADAALTAQUIMICA-PETROQUIMICAACIMA DE 1 ANOLARANJA2005-11-03NaNNaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseFalseNAOFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN529a1f5fc6f88071db7d38492a0ce7c985c77e9b1c3bb62f5bd2ebec4860a392NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN> 2038.079452NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNENTIDADES EMPRESARIAISFABRICACAO DE PRODUTOS DE MINERAIS NAO METALICOSOESTE POTIGUARPAU DOS FERROSINDUSTRIAS DE TRANSFORMACAO48.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNINDUSTRIARNRNNaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
6NaNNaNNaNNaNATE R$ 81.000,00ATE R$ 81.000,00NaNEMPRESARIO INDIVIDUALMEDIATRANSPORTE, ARMAZENAGEM E CORREIOACIMA DE 1 ANOAMARELO2011-07-21NaNNaNNaNFalseTrueFalseFalseTrueFalseTrueTrueTrueTrueSIMFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN8bf37c178778e537b108e58bf20552abe10c3a7fae129b04b52506188e7176daNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN5 a 107.276712NaN63.0NaNNaNNaN63.0NaN63.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSTRANSPORTE TERRESTRENORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISTRANSPORTE ARMAZENAGEM E CORREIO23.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇOMAMANaNNaNNaNNaNNaNNaN50000.050000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
7NaNNaNNaNNaNNaNNaNNaNEMPRESARIO INDIVIDUALALTASERVICOS ADMINISTRATIVOSNaNNaN2018-10-09NaNNaNNaNFalseTrueFalseFalseTrueFalseTrueNaNNaNTrueSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN0114fd3fbdc347c561843cde6aece12e8e53cb5d32c77dd2d5cb382605b7be79NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<= 10.052055NaN40.0NaNNaNNaN40.0NaN40.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSAGENCIAS DE VIAGENS OPERADORES TURISTICOS E SERVICOS DE RESERVASLESTE POTIGUARNATALATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARESNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaN1.0NaNNaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇORNRNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
8NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00BOACOOPERATIVAALTABENS DE CONSUMOACIMA DE 1 ANOAZUL2006-07-27247.88NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseTrueTrueNAOFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN6c45aabb849a760a3a7107c7a61262642f683feb8912a41a859f69fe4ce02b1cNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN10 a 1512.263014NaN36.0NaNNaNNaN36.0NaN36.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNENTIDADES EMPRESARIAISFABRICACAO DE PRODUTOS DIVERSOSCENTRO AMAZONENSEPARINTINSINDUSTRIAS DE TRANSFORMACAO24.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN2.0NaNNaN1.0NaN2.00.0NaNNaNNaNNaNNaN1.0NaNNaNINDUSTRIAAMAMNaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
9367.666667NaN176.7NaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 360.000,01 A R$ 1.500.000,00NaNEMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOVERMELHO2004-10-301042.854200000.013440000.0FalseFalseFalseFalseFalseFalseFalseFalseFalseFalseNAOFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN2fcd678d71b04ccb77644fff57706bdc7fcfbbec6b19267e6600f46121b726e8NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN15 a 2017.942466367.66666752.0235.478333235.478333NaN52.0176.752.0210000.0840000.03.0NaNNaNNaNNaNNaN2.100000e+056.720000e+052.428571NaNNaNNaNNaNNaNNaN210000.0210000.02.0NaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTAOESTE POTIGUARMOSSOROCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS54.0NaNNaNNaNNaNNaNNaNNaNNaNNaN5.06.00.00.00.00.00.00.020.00.00.00.020.00.00.00.00.00.011.00.00.020.00.00.00.00.00.00.00.0NaNNaNNaN3NaNNaNNaNNaNNaNNaN3.01.01.020.0NaN1.0NaN1.00.0NaNNaNNaNNaNNaNNaNNaN1.0COMERCIORNRN1050000.0NaN17.0NaNNaNNaN210000.0840000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0

Last rows

coligada_mais_antiga_ativacoligada_mais_antiga_baixadacoligada_mais_nova_ativacoligada_mais_nova_baixadade_faixa_faturamento_estimadode_faixa_faturamento_estimado_grupode_indicador_telefonede_natureza_juridicade_nivel_atividadede_ramode_saude_rescenciade_saude_tributariadt_situacaoempsetorcensitariofaixarendapopulacaofaturamento_est_coligadosfaturamento_est_coligados_gpfl_anttfl_emailfl_eppfl_ltdafl_matrizfl_mefl_meifl_optante_simeifl_optante_simplesfl_passivel_issfl_rmfl_safl_simples_irregularfl_spafl_st_especialfl_telefonefl_veiculograu_instrucao_macro_analfabetograu_instrucao_macro_desconhecidograu_instrucao_macro_escolaridade_fundamentalgrau_instrucao_macro_escolaridade_mediagrau_instrucao_macro_escolaridade_superiorididade_acima_de_58idade_ate_18idade_de_19_a_23idade_de_24_a_28idade_de_29_a_33idade_de_34_a_38idade_de_39_a_43idade_de_44_a_48idade_de_49_a_53idade_de_54_a_58idade_emp_catidade_empresa_anosidade_maxima_coligadasidade_maxima_sociosidade_media_coligadasidade_media_coligadas_ativasidade_media_coligadas_baixadasidade_media_sociosidade_minima_coligadasidade_minima_sociosmax_faturamento_est_coligadosmax_faturamento_est_coligados_gpmax_filiais_coligadosmax_funcionarios_coligados_gpmax_meses_servicosmax_meses_servicos_allmax_vl_folha_coligadosmax_vl_folha_coligados_gpmedia_faturamento_est_coligadosmedia_faturamento_est_coligados_gpmedia_filiais_coligadosmedia_funcionarios_coligados_gpmedia_meses_servicosmedia_meses_servicos_allmedia_vl_folha_coligadosmedia_vl_folha_coligados_gpmeses_ultima_contratacacomin_faturamento_est_coligadosmin_faturamento_est_coligados_gpmin_filiais_coligadosmin_funcionarios_coligados_gpmin_meses_servicosmin_meses_servicos_allmin_vl_folha_coligadosmin_vl_folha_coligados_gpnatureza_juridica_macronm_divisaonm_meso_regiaonm_micro_regiaonm_segmentonu_meses_rescenciapercent_func_genero_fempercent_func_genero_mascqt_admitidosqt_admitidos_12mesesqt_alteracao_socio_180dqt_alteracao_socio_365dqt_alteracao_socio_90dqt_alteracao_socio_totalqt_artqt_coligadasqt_coligadosqt_coligados_agropecuariaqt_coligados_atividade_altoqt_coligados_atividade_baixoqt_coligados_atividade_inativoqt_coligados_atividade_medioqt_coligados_atividade_mt_baixoqt_coligados_ativoqt_coligados_baixadaqt_coligados_ccivilqt_coligados_centroqt_coligados_comercioqt_coligados_eppqt_coligados_exteriorqt_coligados_inaptaqt_coligados_industriaqt_coligados_ltdaqt_coligados_matrizqt_coligados_meqt_coligados_meiqt_coligados_nordesteqt_coligados_norteqt_coligados_nulaqt_coligados_saqt_coligados_serviçoqt_coligados_sudesteqt_coligados_sulqt_coligados_suspensaqt_desligadosqt_desligados_12mesesqt_ex_funcionariosqt_filiaisqt_funcionariosqt_funcionarios_12mesesqt_funcionarios_24mesesqt_funcionarios_coligadosqt_funcionarios_coligados_gpqt_funcionarios_grupoqt_ramos_coligadosqt_regioes_coligadosqt_sociosqt_socios_coligadosqt_socios_femininoqt_socios_masculinoqt_socios_pepqt_socios_pfqt_socios_pjqt_socios_pj_ativosqt_socios_pj_baixadosqt_socios_pj_inaptosqt_socios_pj_nulosqt_socios_pj_suspensosqt_socios_st_regularqt_socios_st_suspensaqt_ufs_coligadossetorsg_ufsg_uf_matrizsum_faturamento_estimado_coligadastotaltotal_filiais_coligadostx_crescimento_12mesestx_crescimento_24mesestx_rotatividadevl_faturamento_estimado_auxvl_faturamento_estimado_grupo_auxvl_folha_coligadosvl_folha_coligados_gpvl_frotavl_idade_maxima_socios_pjvl_idade_media_socios_pjvl_idade_minima_socios_pjvl_potenc_cons_oleo_gasvl_total_tancagemvl_total_tancagem_grupovl_total_veiculos_anttvl_total_veiculos_antt_grupovl_total_veiculos_levesvl_total_veiculos_leves_grupovl_total_veiculos_pesadosvl_total_veiculos_pesados_grupo
1990NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 360.000,01 A R$ 1.500.000,00NaNSOCIEDADE EMPRESARIA LIMITADAMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOVERMELHO2006-12-021733.06NaNNaNFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseNAOFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN55d44caf6853a4e743b307f58f6e419cd3194ddcfdcf496389557a2bc5e4e4b4NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN> 2028.542466NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNENTIDADES EMPRESARIAISCOMERCIO VAREJISTAOESTE POTIGUARVALE DO ACUCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS22.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCOMERCIORNRNNaNNaNNaNNaNNaNNaN210000.0420000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
1991NaNNaNNaNNaNNaNNaNNaNEMPRESARIO INDIVIDUALBAIXASERVICOS DE ALOJAMENTO/ALIMENTACAOSEM INFORMACAOCINZA2018-04-16NaNNaNNaNFalseFalseFalseFalseTrueFalseTrueNaNNaNTrueNAOFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN47b9cfb6af1ee3a9dbf9f3ab07ac27f9d41fc0379335dbe03b4cc648cea80464NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<= 10.534247NaN40.0NaNNaNNaN40.0NaN40.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSALIMENTACAONaNNaNALOJAMENTO E ALIMENTACAONaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaN1.0NaNNaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇORORONaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
1992NaNNaNNaNNaNNaNNaNNaNCANDIDATO A CARGO POLITICO ELETIVONaNSERVICOS DIVERSOSNaNNaN2018-08-14NaNNaNNaNFalseTrueFalseFalseTrueFalseFalseNaNNaNTrueSIMFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaNa7cb40a5415cfc1638fd8b51b31c189ef9902070bb6e139d0a5612098d2d5995NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<= 10.205479NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCARGO POLITICOATIVIDADES DE ORGANIZACOES ASSOCIATIVASNORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISOUTRAS ATIVIDADES DE SERVICOSNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇOMAMANaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
1993NaNNaNNaNNaNDE R$ 360.000,01 A R$ 1.500.000,00DE R$ 360.000,01 A R$ 1.500.000,00NaNEMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOAZUL2011-01-17898.18NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseTrueFalseNAOFalseFalseFalseFalseFalseFalseNaNNaNNaN2.01.06034e37dc7ac83441836259dc9c02854fce0a6100fded9a010ec0db179eca5761.0NaNNaNNaN2.0NaNNaNNaNNaNNaN5 a 107.783562NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN94.294.2NaNNaNNaNNaNNaNNaN74.62222255.513333NaNNaN39.466667NaNNaNNaNNaN39.46666714.2NaNNaNOUTROSCOMERCIO VAREJISTASUL MARANHENSEPORTO FRANCOCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS22.066.6733.335.00.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN2.00.02.003.03.03.0NaNNaN3.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCOMERCIOMAMANaN3.0NaN0.00.00.0556372.8556372.8NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
1994NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALMEDIASIDERURGICA-METALURGIAATE 1 ANOCINZA2017-04-30690.18NaNNaNFalseFalseFalseFalseTrueFalseTrueNaNNaNFalseSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaNe3398e8ddd4212305a29d3bc0a7a7381959ca3f2c5fbaee9abc28d0ab85f0e8fNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 51.495890NaN20.0NaNNaNNaN20.0NaN20.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSFABRICACAO DE PRODUTOS DE METAL EXCETO MAQUINAS E EQUIPAMENTOSCENTRO AMAZONENSEMANAUSINDUSTRIAS DE TRANSFORMACAO9.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaNNaNNaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNINDUSTRIAAMAMNaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
1995NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00BOAASSOCIACAO PRIVADAALTACULTURA, ESPORTE E RECREACAOACIMA DE 1 ANOVERDE2005-11-033321.86NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN9607a5802e8e4aa7de7890043283082d764290b97cf239acdd998c06609c3e3dNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN> 2037.728767NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNENTIDADES SEM FINS LUCRATIVOSATIVIDADES ESPORTIVAS E DE RECREACAO E LAZERCENTRO NORTE PIAUIENSETERESINAARTES CULTURA ESPORTE E RECREACAO26.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaNNaNNaN1.00.0NaNNaNNaNNaNNaNNaNNaNNaNSERVIÇOPIPINaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
1996NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALBAIXATRANSPORTE, ARMAZENAGEM E CORREIOSEM INFORMACAOCINZA2018-01-29660.83NaNNaNFalseFalseFalseFalseTrueFalseTrueNaNNaNTrueNAOFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaNb5a8faacbf4ffb9f9e484fc0834f8f7e949de93fba37160b36f4fd670d96a7d0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<= 10.745205NaN28.0NaNNaNNaN28.0NaN28.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSTRANSPORTE TERRESTRESUDOESTE PIAUIENSESAO RAIMUNDO NONATOTRANSPORTE ARMAZENAGEM E CORREIONaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaN1.0NaNNaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇOPIPINaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
1997NaNNaNNaNNaNATE R$ 81.000,00ATE R$ 81.000,00NaNEMPRESARIO INDIVIDUALALTACOMERCIO VAREJISTAACIMA DE 1 ANOVERDE2014-09-02NaNNaNNaNFalseTrueFalseFalseTrueFalseTrueTrueTrueTrueSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN34c74885c6f792ec82587c2b4d93fb4791f8367b8c6e1b9e10c17eb6111944dcNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 54.156164NaN35.0NaNNaNNaN35.0NaN35.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTACENTRO AMAZONENSEMANAUSCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS47.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIOAMAMNaNNaNNaNNaNNaNNaN50000.050000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
1998NaNNaNNaNNaNATE R$ 81.000,00ATE R$ 81.000,00NaNEMPRESARIO INDIVIDUALALTASERVICOS DE ALOJAMENTO/ALIMENTACAOACIMA DE 1 ANOVERDE2016-08-173597.12NaNNaNFalseTrueFalseFalseTrueFalseTrueTrueTrueTrueNAOFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN748fa25fe9ab6098ca9fefae265b5df3a57cb7ab27b0414623022430a269291cNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 52.197260NaN29.0NaNNaNNaN29.0NaN29.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSALIMENTACAOVALE DO ACRERIO BRANCOALOJAMENTO E ALIMENTACAO23.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaN1.0NaNNaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇOACACNaNNaNNaNNaNNaNNaN50000.050000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
1999NaNNaNNaNNaNDE R$ 360.000,01 A R$ 1.500.000,00DE R$ 360.000,01 A R$ 1.500.000,00NaNEMPRESARIO INDIVIDUALALTACOMERCIO POR ATACADOACIMA DE 1 ANOAZUL2005-11-03765.23NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseFalseSIMFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN02358bfbe4d3297235e3998662e20f9bc1455755719cc3961c677acca49b59f7NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN15 a 2017.189041NaN61.0NaNNaNNaN61.0NaN61.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETASLESTE POTIGUARNATALCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS22.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaN1.0NaNNaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIORNRNNaNNaNNaNNaNNaNNaN930000.0930000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0